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
2768
February 09, 2012 03:30AM
1645
February 09, 2012 05:31AM
1326
February 09, 2012 05:38AM
1196
February 09, 2012 05:58PM
1188
February 11, 2012 11:26PM
1458
February 12, 2012 10:12PM
1311
February 13, 2012 02:18PM
1476
February 14, 2012 02:33AM
1249
February 14, 2012 07:24AM
1335
February 15, 2012 07:30AM
1742
February 16, 2012 03:54AM
1229
February 17, 2012 01:20AM
1124
February 17, 2012 03:57PM
1442
February 17, 2012 05:12PM
1268
February 18, 2012 07:18AM
Re: how to optimise query for 10+ millions records
1279
February 21, 2012 03:25AM
1305
February 24, 2012 10:45AM
1240
February 20, 2012 02:21AM