[R] SQL vs R

Dr Eberhard Lisse el at lisse.NA
Tue May 6 13:08:14 CEST 2014


Thanks,

tried all of that, too slow.

el

on 2014-05-06, 12:00 Gabor Grothendieck said the following:
> On Tue, May 6, 2014 at 5:12 AM, Dr Eberhard Lisse <el at lisse.na> wrote:
>> Jeff
>>
>> It's in MySQL, at the moment roughly 1.8 GB, if I pull it into a
>> dataframe it saves to 180MB. I work from the dataframe.
>>
>> But, it's not only a size issue it's also a speed issue and hence
>> I don't care what I am going to use, as long as it is fast.
>>
>> sqldf is easy to understand for me but it takes ages.  If
>> alternatives were roughly similar in speed I would remain with
>> sqldf.
>>
>> dplyr sounds faster, and promising, but the intrinsic stuff is
>> way beyond me (elderly Gynaecologist) on the learning curve...
> 
> You can create indices in sqldf and that can speed up processing
> substantially for certain operations.  See examples 4h and 4i on
> the sqldf home page: http://sqldf.googlecode.com.  Also note that
> sqldf supports not only the default SQLite backend but also MySQL,
> h2 and postgresql.  See ?sqldf for info on using sqldf with MySQL
> and the others.
> 

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el at lisse.NA            / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /
Bachbrecht, Namibia     ;____/



More information about the R-help mailing list