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). thanks, Natalie Hawkins Statistical Research Associate FHCRC/Scharp -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read 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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
On Thu, 1 Mar 2001, Natalie Hawkins wrote:> > 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).Yes, some experience with all. We need more to go on: your chosen OS, for example. Have you looked at my article in R-news 2001-1? It even has some recommendations .... Looks like I would recommend MySQL + RODBC on Windows/Linux, perhaps RMySQL elsewhere provided you only ever wanted to read from the tables. -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, stats.ox.ac.uk/~ripley University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272860 (secr) Oxford OX1 3TG, UK Fax: +44 1865 272595 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read 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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> > 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 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 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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._