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
3359
February 09, 2012 03:30AM
1863
February 09, 2012 05:31AM
1554
February 09, 2012 05:38AM
1436
February 09, 2012 05:58PM
1408
February 11, 2012 11:26PM
1676
February 12, 2012 10:12PM
1534
February 13, 2012 02:18PM
1734
February 14, 2012 02:33AM
1554
February 14, 2012 07:24AM
1551
February 15, 2012 07:30AM
2047
February 16, 2012 03:54AM
1439
February 17, 2012 01:20AM
1409
February 17, 2012 03:57PM
1691
February 17, 2012 05:12PM
1514
February 18, 2012 07:18AM
Re: how to optimise query for 10+ millions records
1524
February 21, 2012 03:25AM
1565
February 24, 2012 10:45AM
1503
February 20, 2012 02:21AM