RE: [PHP-DB] Is Temporary table right approach

arch Inst. 700 Ellicott St. Buffalo, NY 14203 Phone: 716-898-8637 Fax: 716-898-8660 http://www.chtsb.org http://www.hwi.buffalo.edu -Original Message- From: Daniel Carrera [mailto:daniel.carr...@theingots.org] Sent: Wednesday, April 15, 2009 5:10 AM To: php-db@lists.php.net Subject: Re

Re: [PHP-DB] Is Temporary table right approach

I think a temporary table is likely to be the right approach. I have some times found massive seed improvements by caching a result set inside a temporary table. If the data in the table is just ids (ie, just one field), you could get an additional speed bump by rewriting your WHERE clause to

[PHP-DB] Is Temporary table right approach

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