[R] SQL vs R

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Tue May 6 10:41:23 CEST 2014


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.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

On May 6, 2014 1:16:12 AM PDT, Eberhard Lisse <nospam at lisse.na> wrote:
>Thank you.
>
>My requirements are that simple. One table, 11 fields, of which 3 are
>interesting, 30 Million records, growing daily by between 300000.
>
>And, yes I have spent an enormous amount of time reading these things,
>but for someone not dealing with this professionally and/or on a daily
>basis, the documents don't help much.
>
>el
>
>
>on 2014-05-04, 05:26 Jeff Newmiller said the following:
>> ?table
>> ?aggregate
>> 
>> Also, packages plyr, data.table, and dplyr.  You might consider
>> reading [1], but if your interests are really as simple as your
>> examples then the table function should be sufficient.  That
>> function is discussed in the Introduction to R document that you
>> really should have read before posting here.
>> 
>> [1] http://www.jstatsoft.org/v40/i01/
>[...]



More information about the R-help mailing list