MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Help optimizing a SELECT WHERE GROUP BY query
Posted by: Rob Blick
Date: September 02, 2005 08:29AM

Hey Roland-
Thanks... changing to int cut the time by 30%. The rest may just need more hardware. The index is being used, according to EXPLAIN, but the query still takes 20 sec to run. The .MYI file is 325MB, and if I assume it's gotta read the whole thing sequentially, that works out to 16MB/s, which is a little low but doesn't seem too bad when you consider that some of that time is spent doing all sorts of other CPU tasks. Sound right?

Thanks!
Rob

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


Subject
Views
Written By
Posted
Help optimizing a SELECT WHERE GROUP BY query
4528
Rob Blick
August 25, 2005 01:41PM
Re: Help optimizing a SELECT WHERE GROUP BY query
2024
Daniel Nichter
August 26, 2005 10:35AM
Re: Help optimizing a SELECT WHERE GROUP BY query
2124
Rob Blick
August 26, 2005 12:19PM
Re: Help optimizing a SELECT WHERE GROUP BY query
1740
Roland Bouman
August 28, 2005 02:56AM
Re: Help optimizing a SELECT WHERE GROUP BY query
1978
Rob Blick
September 02, 2005 08:29AM
Re: Help optimizing a SELECT WHERE GROUP BY query
1948
Roland Bouman
September 02, 2005 12:09PM
Re: Help optimizing a SELECT WHERE GROUP BY query
1690
Jay Pipes
September 05, 2005 11:42AM


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.