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
2771
February 09, 2012 03:30AM
1646
February 09, 2012 05:31AM
1329
February 09, 2012 05:38AM
1199
February 09, 2012 05:58PM
1191
February 11, 2012 11:26PM
1460
February 12, 2012 10:12PM
1313
February 13, 2012 02:18PM
1478
February 14, 2012 02:33AM
1255
February 14, 2012 07:24AM
1339
February 15, 2012 07:30AM
1744
February 16, 2012 03:54AM
1230
February 17, 2012 01:20AM
1128
February 17, 2012 03:57PM
1445
February 17, 2012 05:12PM
1271
February 18, 2012 07:18AM
Re: how to optimise query for 10+ millions records
1284
February 21, 2012 03:25AM
1307
February 24, 2012 10:45AM
1246
February 20, 2012 02:21AM