MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: SELECT takes 20 seconds
Posted by: Felix Geerinckx
Date: June 17, 2005 11:57AM

Tony Galan wrote:

> Any tips on how to speed things up?

Not unless you show

1) DESCRIBE yourtable;
for all tables involved in your SELECT

2) EXPLAIN SELECT ....;
for your query

--
felix
Please use BBCode to format your messages in this forum.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
SELECT takes 20 seconds
Tony Galan
June 17, 2005 11:38AM
Re: SELECT takes 20 seconds
Felix Geerinckx
June 17, 2005 11:57AM


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.