[R] my RMySQL connections are so SLOW

Prof Brian Ripley ripley at stats.ox.ac.uk
Mon May 5 11:32:34 CEST 2003


What exactly are you timing?  For me running a query is instant.
Are you starting R for each query, for example?  What OS and what hardware 
are you using?

People have reported that RODBC is a lot faster than RMySQL for some tasks 
involving large datasets.

On Mon, 5 May 2003, Laurent Faisnel wrote:

> I'm using the latest RMySQL to send requests to a MySQL database (which 
> is quite small for the time - let's say 20 tables with a total of 1000 
> rows), and this should be part of a whole decisionnal system. It 
> produces results which are displayed on a website, and therefore I need 
> fast results (the database being quite small, I think this must be 
> possible !).
> Unfortunately, a simple request to the database, and R needs more than 
> 10 seconds. Even dbListTables() takes a long while. Imagine the problem 
> with more data ! Can I hope something better  with RMySQL ? Did anyone 
> have the same problem ?
> If RMySQL (or is it MySQL's fault ?) is so slow, I could replace MySQL 
> with Postgres, but this would imply a lot of extra work. R is perhaps 
> very slow anyway ? Any piece of advice ?

-- 
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




More information about the R-help mailing list