MySQL Forums
Forum List  »  Optimizer & Parser

Re: how to optimise query for 10+ millions records
Posted by: Azhar Rahi
Date: February 21, 2012 03:25AM

Well one thing I want to share.

I have created another index with Fields (`START_DATE`,`START_TIME`,`DUR`,`DestinationID`).

Now the response time decrease more than 2-3 times (in some cases 3-4 times). So Now if I search the dates '2012-01-27' to '2012-02-03', it returns records in 15-16 seconds, while before its response time was more or less 50 seconds.

I still believe that the response time can be keep down up to 3-4 seconds for the above filter. May be partitions help us.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to optimise query for 10+ millions records
1069
February 21, 2012 03:25AM


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.