using MySQL server version 3.23.36 under RH Linux 7.1.
Thanks for any support you can offer.
David Keeney
--- End of forwarded message ---
--
David Keeney [EMAIL PROTECTED]
Travel By Road http://www.travelbyroad.net
the database with a succession of
'Select ... ' queries? A statement like 'Select * from Tiger_main limit
1,1' is very slow, and iterating over the entire table would take
weeks.
I am using MySQL server version 3.23.36 under RH Linux 7.1.
Thanks for any support you can
server performance and diagnose the problem.
Thank you
David
David Keeney [EMAIL PROTECTED]
Travel By Road http://www.travelbyroad.net
-
Before posting, please check:
http://www.mysql.com/manual.php
recreating the index to no avail, and have
dropped other indexes that I thought might possibly be confusing the
optimizer. No improvement.
Is there a way, through the Perl DBI interface, to determine whether
a given SELECT query is using indexes?
Thank you for any assistance offered.
David Keeney
