MySQL Forums
Forum List  »  Optimizer & Parser

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to optimise query for 10+ millions records
1737
February 16, 2012 03:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.