[R] SQL vs R

Thomas Lumley tlumley at uw.edu
Wed May 7 02:00:16 CEST 2014


On Wed, May 7, 2014 at 2:21 AM, David R Forrest <drf at vims.edu> wrote:
> It sounds as if your underlying MySQL database is too slow for your purposes.  Whatever you layer on top of it will be constrained by the underlying database.  To speed up the process significantly, you may need to do work on the database backend part of the process.


You might try MonetDB and its R interface -- it is fast for
aggregation operations, and either the current version or the upcoming
version has dplyr support.

    -thomas

-- 
Thomas Lumley
Professor of Biostatistics
University of Auckland



More information about the R-help mailing list