Re: Simple Query takes 50 seconds with Indexing
Thanks Peter and Rick.
I've applied what Peter suggested and the query was still slow.
As for the changing of innodb_buffer_pool_size it significantly increased my query. It seems that I should been looking more on other possible problems than just focusing on the data structure and optimizing my query.
Also, adding a LIMIT clause did the trick, since I'll be using paging anyway.
Thanks a lot for your help!
Subject
Views
Written By
Posted
2119
July 21, 2011 08:26AM
1224
July 21, 2011 11:34AM
871
July 21, 2011 10:04PM
Re: Simple Query takes 50 seconds with Indexing
868
July 22, 2011 11:01PM
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.