Re: how to optimise query for 10+ millions records
Posted by:
Azhar Rahi
Date: February 16, 2012 03:54AM
I will test the suggestion about indexing later.
Yes, I said 10 million, but this 10 million record got inserted just in 10-12 days, so although later, it can exceed records upto billion as I think so.
Well one thing I need to ask? How can I create IN list. Because I am getting a comma separated string 'sedomii, navobbio'. and IN List needs ('sedomii','navobbio'). I have no choice other than to create a temporaray table.
Also when I tried to use Temporaray tables in Joins instead of using IN (Select...), it changes the recordset. With In (Select ...), it returns the records multiply my the records in the Tmep table. i.e. if there are one record, it will show total calls 256, but if there are 2 reccords, it shows 512 and if it has 3 then it shows 768 and so on. I am using inner join with this temp table.
Subject
Views
Written By
Posted
2866
February 09, 2012 03:30AM
1700
February 09, 2012 05:31AM
1363
February 09, 2012 05:38AM
1262
February 09, 2012 05:58PM
1249
February 11, 2012 11:26PM
1499
February 12, 2012 10:12PM
1352
February 13, 2012 02:18PM
1563
February 14, 2012 02:33AM
1349
February 14, 2012 07:24AM
1372
February 15, 2012 07:30AM
Re: how to optimise query for 10+ millions records
1826
February 16, 2012 03:54AM
1264
February 17, 2012 01:20AM
1223
February 17, 2012 03:57PM
1504
February 17, 2012 05:12PM
1308
February 18, 2012 07:18AM
1370
February 21, 2012 03:25AM
1359
February 24, 2012 10:45AM
1305
February 20, 2012 02:21AM