[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

[PHP-DB] Re: php-win-which-orm-tool-for-windows-with.html

2009/4/14 Alvaro Carrasco alv...@fractaldata.net: Hi Richard, Sorry about not sending to the list, I found this post while browsing the internet and i'm not subscribed to the php-windows list. Hi. I'm trying to find an ORM tool to allow me to talk to Microsoft SQL servers (V7, 2000 and

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

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

Keeping in mind of course that the temporary table you create is only accessible to the user who created it, and for the length of that session connection. Once your script has finished executing and the connection to the database is released, that temporary table no longer exists. Net affect:

[PHP-DB] Re: php-win-which-orm-tool-for-windows-with.html

See below On Wed, Apr 15, 2009 at 1:56 AM, Richard Quadling rquadl...@googlemail.comwrote: 2009/4/14 Alvaro Carrasco alv...@fractaldata.net: Hi Richard, Sorry about not sending to the list, I found this post while browsing the internet and i'm not subscribed to the php-windows list.