MySQL Forums
Forum List  »  Perl

Re: MySQL is slow.
Posted by: Nick Roper
Date: May 02, 2005 04:17AM


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



Nick Roper

Options: ReplyQuote

Written By
May 01, 2005 11:22PM
May 02, 2005 12:45AM
Re: MySQL is slow.
May 02, 2005 04:17AM
May 02, 2005 09:10PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.