Not without more information. At the very least, we need to see the query.
Better yet, show us what EXPLAIN has to say about your query
<http://dev.mysql.com/doc/mysql/en/EXPLAIN.html>.
Michael
Jason Williard wrote:
Hello,
I recently began experiencing issues that I would like some assistance
with.
Server Details:
- Windows 2003
- MySQL Max 4.0.20a
I have a table with 450,000+ records in it. When I try to run a single
query, such as selecting 1 row or deleting 1 row using the WHERE clause,
the query can take forever to run. In a specific case, it took 57
seconds to complete the SELECT query.
Any ideas on how to speed this up?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]