Message-ID: <3EB62755.3030807@ariase.com>
Date: 2003-05-05T08:56:53Z
From: Laurent Faisnel
Subject: my RMySQL connections are so SLOW
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