[R] Transforming relational data

Gabor Grothendieck ggrothendieck at gmail.com
Wed Feb 23 19:00:18 CET 2011


On Wed, Feb 23, 2011 at 10:46 AM, mathijsdevaan <mathijsdevaan at gmail.com> wrote:
>
> Thanks Matthew that worked great. What a great forum this is: I am learning a
> lot!
>
> PS. I am now running both solutions on two similar computers. Let's see
> which is fastest.

If your data is small its pointless to be concerned with speed.  How
expressive the code is is more important.

If your data is large then you may need to create indexes on the
tables to speed it up. This is illustrated on the sqldf home page.

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com



More information about the R-help mailing list