Take a look at the docs for EXPLAIN (manual.html#IDX853). Use the 'possible_keys' column of the results to determine which column indexes will improve your query performance.
Make sure your table has a primary key. Whenever possible, use the primary key in your WHERE clause when you SELECT or UPDATE a single row. You might get better results from this list if you include your table structure and your queries along with your question. Randy Clamons Systems Programming Astro-auction.com > ------------Original Message------------ > From: "Danny Willis" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] > Date: Wed, Oct-6-2004 1:02 PM > Subject: RE: Long Running Queries > > What do you mean by "appropriate indexes?" > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 06, 2004 3:43 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Long Running Queries > > 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? > -- > > Thank You, > Jason Williard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
