[R] Transforming relational data

[Gabor Grothendieck]

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