[R] db pkgs

[Torsten Hothorn]

> 
> Hi,
> 
> I am wondering if anyone has had experience w/the R database
> packages: RMySQL, RODBC, RPgSQL, and/or RmSQL, and if so, if you have
> any recommendations to make.  We have some large tables we would like to
> store -- something like 5-10 columns by 3.5 mil rows (or maybe 7 mil
> rows).

You might have a look at the Data Import/Export manual. Using the
data within R (summary or modelling) currently requires all the data as
data.frame, and 7 mil rows may bring even R to it's knees. 

Beside that, IMO MySQL is fast enough and easy to handle and RMySQL is
straightforward, too. 

Torsten

> 
> thanks,
> 
> Natalie Hawkins
> Statistical Research Associate
> FHCRC/Scharp
> 
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> 

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._