MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimize sub query with large group by
Posted by: Alex K
Date: March 17, 2011 12:40AM

Oystein your query works however it takes longer and still includes the group by object_id which seemed to be what was taking so long.

I have been testing this on a laptop and hadn't increased the buffer_pool_size much. I checked the IO and most of it was fetching from disk.
Thanks Rick.

I tested the same query on the actual server and it only took 4 sec compared to 120 sec. This is much faster but I'm not sure what I should be expecting the speed to be (could it be faster?).

Still wonder if there is a better way to get the same result with a different query.

Thanks all for the help.

Options: ReplyQuote

Written By
March 10, 2011 07:44PM
Re: Optimize sub query with large group by
March 17, 2011 12:40AM

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.