[R] my RMySQL connections are so SLOW

[Ernesto Jardim]

On Mon, 2003-05-05 at 09:56, Laurent Faisnel wrote:
> Hi all,
> 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 ?
> Thanks.
> Laurent
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help

Hi

Have you tried to run the sql statement in mysql to check if the problem
is really in RMySQL ? MySQL databases can be very slow if you don't
index the tables. 

Check
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#MySQL_indexes

Regards

EJ