Hi All, Thanks for your valuable input. I have decided to use temporary table approach. Since I am using it for the first time and this has to be done in the production server. Do I need to consider some facts before using this such as setting some parameters in my.cnf etc or the MYSQL will handle all. Actually I want to know if any one has faces issues practically when implementing temporary tables. Waiting for your suggestion. Thanks, Manoj On Fri, Apr 17, 2009 at 8:21 AM, Moon's Father <yueliangdao0608@xxxxxxxxx>wrote: > 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 <manojsingh2121@xxxxxxxxx>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 >
