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
2885
February 09, 2012 03:30AM
1713
February 09, 2012 05:31AM
1373
February 09, 2012 05:38AM
1277
February 09, 2012 05:58PM
1258
February 11, 2012 11:26PM
1509
February 12, 2012 10:12PM
1362
February 13, 2012 02:18PM
1576
February 14, 2012 02:33AM
1360
February 14, 2012 07:24AM
1383
February 15, 2012 07:30AM
1840
February 16, 2012 03:54AM
1276
February 17, 2012 01:20AM
1232
February 17, 2012 03:57PM
1516
February 17, 2012 05:12PM
1319
February 18, 2012 07:18AM
Re: how to optimise query for 10+ millions records
1379
February 21, 2012 03:25AM
1371
February 24, 2012 10:45AM
1315
February 20, 2012 02:21AM