[R] Reading huge chunks of data from MySQL into Windows R

From: Dubravko Dolic <Dubravko.Dolic_at_komdat.com>
Date: Mon 06 Jun 2005 - 23:30:31 EST

Dear List,  

I'm trying to use R under Windows on a huge database in MySQL via ODBC (technical reasons for this...). Now I want to read tables with some 160.000.000 entries into R. I would be lucky if anyone out there has some good hints what to consider concerning memory management. I'm not sure about the best methods reading such huge files into R. for the moment I spilt the whole table into readable parts stick them together in R again.  

Any hints welcome.      

Dubravko Dolic

Statistical Analyst  

Email: dubravko.dolic@komdat.com

        [[alternative HTML version deleted]]

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 Mon Jun 06 23:47:57 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:23 EST