Re: MySQL is slow.

[Nick Roper]

Howard,

It could be all sorts of things, either with the mysql server, or with the perl code. The first thing to do is try executing the query at the mysql> prompt. If it works OK then it indicates an issue with the connection or the script. Can you try using the following command at the mysql> prompt

EXPLAIN SELECT select_options and then posting the output. e.g.

mysql> EXPLAIN SELECT col1, col2 FROM table1, table2 WHERE etc....

Cheers,

Nick

--
Nick Roper