Re: [R] RMySQL query: why result takes so much memory in R ?

2005-05-02 Thread christian schulz
Hi, IMHO you need only when your columns are numeric X rows /100/100/8 MB. >>(1200*3)/100/100/8 [1] 450 But one of your columns is group char. I'm suffering in the past in lot of things with massive data and R and recognize doing how many as possible in the database, or you have to upgrade

Re: [R] RMySQL query: why result takes so much memory in R ?

2005-05-02 Thread Duncan Murdoch
Christoph Lehmann wrote: Hi I just started with RMySQL. I have a database with roughly 12 millions rows/records and 8 columns/fields. From all 12 millions of records I want to import 3 fields only. The fields are specified as:id int(11), group char(15), measurement float(4,2). Why does this tak

[R] RMySQL query: why result takes so much memory in R ?

2005-05-02 Thread Christoph Lehmann
Hi I just started with RMySQL. I have a database with roughly 12 millions rows/records and 8 columns/fields. From all 12 millions of records I want to import 3 fields only. The fields are specified as:id int(11), group char(15), measurement float(4,2). Why does this take > 1G RAM? I run R on sus