I have a question for the R core development team: Are there any near-term plans to incorporate the ODBC API function SQLBulkOperations into the RODBC package? As you are probably well aware, the sqlSave() function uses a row-by-row insert (even in the 'fast' version) that imposes heavy DB transaction overheads as well as unnecessary network transmission overheads. Replacing the current version of the code with a call to SQLBulkOperations could speed up sqlSave function for moderate to large data sets up to 10x.
I am asking so I can decide whether it is worthwhile for me to implement a home-grown version of the code or I can look forward to a new release of RODBC within the next couple of weeks or months. Thank you, Ali -- View this message in context: http://r.789695.n4.nabble.com/Using-SQLBulkOperations-in-RODBC-tp4659205.html Sent from the R devel mailing list archive at Nabble.com. ______________________________________________ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
