I have read a few issues on github relating to write speed, but I have not found a workaround for the problem.
I currently have a 2.5MB file I would like to write to Azure. Below is an example of the code I am using.
The problem is the the write time is close to 40mins! What can I do to speed up the write speed?
# connect to Azure con_azure <- DBI::dbConnect(odbc::odbc(), Driver = "SQL Server Native Client 11.0", Server = "name-server.database.windows.net", Database = "work_dw", UID = "user", PWD = "pass") # write to data to table my_file #2.5MB tictoc::tic() DBI::dbWriteTable(con_azure, DBI::Id(schema = "my_dev", name = "new_table"), my_file) tictoc::toc() # 2305.56 sec elapsed