quot;")
sqlQuery(channel, query)
unlink(tmp_filename)
The total runtime for the LOAD DATA INFILE querys was something below 5
minutes, inserting 3e+6 rows with > 200 columns.
Michel Lang
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz
4
1 2 5
1 3 4
1 3 5
1 4 5
2 3 4
2 3 5
2 4 5
3 4 5
I'm grateful for any advice on how to proceed,
Michel Lang
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting gui
suggestion for the generation of a useful, unique id in your
working dir:
prefix <- paste("var_", var, sep = "")
while(file.exists(id <- basename(tempfile(pattern = prefix {}
save(result, file = paste(id, ".Rdata", sep = ""))
Hope this helps.
M