MySQL Forums
Forum List  »  Newbie

Re: Subset Query Speed Help from .46 second to 7 minutes!
Posted by: Felix Geerinckx
Date: August 11, 2005 08:14AM

Brian Pilati wrote:

> If I run query 1 and query 2 alone the response times are .13 and .43 seconds, respectively.
> However, combined into one query the response time is a whopping 7 plus minutes.

I'd love to see more info on this:

0) 'SELECT VERSION();'
1) 'SHOW CREATE TABLE <table> \G' for all tables involved
2) 'SHOW INDEX FROM <table> \G' for all tables involved
3) 'EXPLAIN <query> \G' for the three queries

But I don't think this is newbie stuff. I would post it in the Performance forum.

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

Options: ReplyQuote


Subject
Written By
Posted
Re: Subset Query Speed Help from .46 second to 7 minutes!
August 11, 2005 08:14AM


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.