Re: Long Running Queries

[Jason Williard]

I'm sorry to sound like a novice, but could you explain that?  Are you 
recommending that I set the column I am searching to an Index?

Thank You,
Jason Williard
Client Services

[EMAIL PROTECTED] wrote:
You need Appropriate Indexes on the tables. 

-----Original Message-----
From: Jason Williard [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 07, 2004 1:11 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Long Running Queries

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]