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
3407
February 09, 2012 03:30AM
1887
February 09, 2012 05:31AM
1581
February 09, 2012 05:38AM
1456
February 09, 2012 05:58PM
1431
February 11, 2012 11:26PM
1708
February 12, 2012 10:12PM
1557
February 13, 2012 02:18PM
1754
February 14, 2012 02:33AM
1570
February 14, 2012 07:24AM
1571
February 15, 2012 07:30AM
Re: how to optimise query for 10+ millions records
2070
February 16, 2012 03:54AM
1467
February 17, 2012 01:20AM
1439
February 17, 2012 03:57PM
1708
February 17, 2012 05:12PM
1542
February 18, 2012 07:18AM
1547
February 21, 2012 03:25AM
1587
February 24, 2012 10:45AM
1531
February 20, 2012 02:21AM