[R] SQL vs R

Dr Eberhard Lisse el at lisse.NA
Tue May 6 11:12:50 CEST 2014


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...

el

on 2014-05-06, 09:41 Jeff Newmiller said the following:
> In what format is this "growing" data stored?  CSV? SQL? Log
> textfile?  You say you don't want to use sqldf, but you haven't
> said what you do want to use.



More information about the R-help mailing list