On Wed, Feb 23, 2011 at 10:46 AM, mathijsdevaan <mathijsdev...@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 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.