Use temporary table can be a good idea. But I think you performance would be boost so much if you can do something else to replace the temporary table. On Wed, Apr 15, 2009 at 2:03 PM, Manoj Singh <manojsingh2...@gmail.com>wrote:
> Hi All, > > I have a query which returns the large number of ids which i am using in > other queries. I am doing this in PHP. Now the first query can return > unlimited number of ids which might create problem in PHP. I want to store > this ids in MYSQL through temporary table so that i can access that ids in > other queries directly. > > Do you think the approach is right or there is any other good approach? > > Please suggest. > > Regards, > Manoj > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
