1

I am looking for the utmost quickest way to import an MSSQL data table into R.

I currently use:

ch <- odbcConnect("Table1", uid="***", pwd="***")
system.time(TransactionFrame <- sqlFetch(ch, "V_Transactions_Extended"))
odbcClose(ch)

There are +/- 5 million rows and about 80 columns. This takes about 60min. I appreciate that this is a function of many things, including network traffic.

Is there a quicker way to import this? I am happy to try any sort of work around; for e.g. copy the MSSQL table onto my C:\ first and then some other quicker import function. Step by step spoon-fulls for me please!

I have also tried RJDBC as suggested here which is not better.

Thanks in advance.

Community
  • 1
  • 1
gmarais
  • 1,801
  • 4
  • 16
  • 32

0 Answers0