Hello everyone,

I have a problem when I execute queries using R 2.3.1 and MySql server 5.0.
What I do: I load data in different csv files (every file represents a
particular temporal step of a simulation) using Mysql query "load data" with
RMySQL command DbSendQuery (but the same problem there is also using
DbWritetable). Then I use a function where I have a lot of queries that
interact with the database.
Well, while loading data is very fast, query execution is very slow
...looking to Windows task manager I see that my cpu doesn't go to 100% of
usage, but only at 30-45%. Looking at the processes I see Rgui.exe use
between 0-23% and mysql-nt.exe use between 8-20% and so it is very slow. I
am sure my cpu has no particular problems.
Could you help me?

Thanks in advance

Davide

	[[alternative HTML version deleted]]

