search for: sqlbulkoperations

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 SQ...

I am using R2.6.0 on “Windows Small Business Server 2003”. I apologize if the answer to my question is available…I have searched but have not found anything that I thought helped me. I have a dataframe that contains ~4.5 million rows and 5 columns. (see memory and df details below). I am trying to save the dataframe to a MS SQL Server database, using the “sqlSave” function. The code