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.
Subject
Views
Written By
Posted
3031
February 09, 2012 03:30AM
1741
February 09, 2012 05:31AM
1400
February 09, 2012 05:38AM
1309
February 09, 2012 05:58PM
1282
February 11, 2012 11:26PM
1537
February 12, 2012 10:12PM
1391
February 13, 2012 02:18PM
1602
February 14, 2012 02:33AM
1406
February 14, 2012 07:24AM
1415
February 15, 2012 07:30AM
1864
February 16, 2012 03:54AM
1304
February 17, 2012 01:20AM
1261
February 17, 2012 03:57PM
1546
February 17, 2012 05:12PM
1348
February 18, 2012 07:18AM
Re: how to optimise query for 10+ millions records
1404
February 21, 2012 03:25AM
1405
February 24, 2012 10:45AM
1347
February 20, 2012 02:21AM