[R] importing a VERY LARGE database from Microsoft SQL into R

From: r user <ruser2006_at_yahoo.com>
Date: Wed 25 Jan 2006 - 07:28:13 EST


I am using R 2.1.1 in a Windows Xp environment.

I need to import a large database from Microsoft SQL into R.

I am currently using the “sqlQuery” function/command.

This works, but I sometimes run out of memory if my database is too big, or it take quite a long time for the data to import into R.

Is there a better way to bring a large SQL database into R?

IS there an efficient way to convert the data into R format prior to bringing it into R? (E.g. directly from Microsoft SQL?)



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Wed Jan 25 08:19:24 2006

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:42:10 EST