On Fri, Oct 15, 2010 at 6:14 AM, Chris Howden <ch...@trickysolutions.com.au> wrote: > Thanks for the advice Gabor, > > I was indeed not starting and finishing with sqldf(). Which was why it was > not working for me. Please forgive a blatantly obvious mistake. > > > I have tried what U suggested and unfortunately R is still having problems > doing the join. The problem seems to be one of memory since I am receiving > the below error message when I run the natural join using sqldf. > Error: cannot allocate vector of size 250.0 Mb > Timing stopped at: 32.8 0.48 34.79 >
Specify an external database so it uses an external, rather than "in memory", database. See example 6b (also shown in several other examples) on the home page: sqldf(c("create...", "create...", "select..."), dbname = tempfile()) -- 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.