[R] my RMySQL connections are so SLOW

[Prof Brian Ripley]

On Mon, 5 May 2003, Laurent Faisnel wrote:

> Thank you for your fast answer. I work on a 450MHz Pentium II with 192 
> MBytes RAM.

And Linux.  That's a rather old spec --  4-5 years?

> dbListTables() takes about 3 seconds. For direct use it's OK, but when 
> requests become included in programs, it makes very slow programs !
>  I had to calculate an average score for each value of a column (i=1:12) 
> to fill an array, and so the operation (pretty simple) took more than 30 
> seconds (almost 3 seconds per "select avg(score)..." request).
> 
> I don't think my dataset is huge enough to make it worth using ODBC, 
> which would cause other problems. I do not start R for each query. I 
> have the same slowness when sending the requests to R directly (without 
> using source code).
> 
> What makes me hope for a solution is when you say "For me running a 
> query is instant". What could be the difference between our systems ? 
> The CPU speed does not explain all, in my opinion.

Well, I am using a dual Athlon 2600, 1Gb RAM and a fast local disc system,
so that is a considerable difference.  Maybe you need more RAM.

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595