Hi,
I am working with a very large dataset, and am using the 'filehash'
package
to manage such a large file.
While I have no problem accessing objects that I load into a database, I was
hoping there is a better way to append to objects already in the database.
The only way I know now to append to an object, basically requires rewriting
the entire object.
Sample code: ================================================
# Setting up the database
library(filehash)
A <- data.frame(a=c("abcde", "fghij", "klmno"),
stringsAsFactors=FALSE)
dumpDF( A, dbName="myTestDB")
envTest <- db2env(db="myTestDB")
ls(envTest)
with(envTest, a)
# Appending to object a, but basically rewriting it...
envTest$a <- c(envTest$a, "HELLO", "GOODBYE")
with(envTest, a)
If anyone has a suggestion on how to append to an object without completely
rewriting it, I would really appreciate it. Because in my actual
implementation, a is a vector of class character with ~3.5 million
elements... writing it (and rewriting it) takes quite a bit of time.
For reference, I am using a Windows Vista machine with:
R.version.string
[1] "R version 2.8.0 (2008-10-20)"
Thanks,
Brigid
[[alternative HTML version deleted]]