my RMySQL connections are so SLOW
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