Does anyone know whether the use of persistent connections with php will allow a temp table created by a script to linger around and cause a problem with the next execution of the script when it tries to create the temp table again?
It won't. If the client looses its connection, the temp table will disappear.
Also if it does present a problem with the next script execution trying to create the temp table again, if I drop the temp table at the end of the script will I still have problems if the script is run by two client in tandem?
It will drop itself if the client looses their connection. You can have many people using a temporary table called "problems" and the table will be different for each client. It is only used for that connection and can NOT be shared by other clients. Each has their own.
For instance two people connect, both hit the script at about the same time. One script creates the temp table and before it can drop the table the second script tries to create the table. Will it see the table created by the other script?
Neither peoples connection will ever see the others temporary table and so both people will have the same name for a temporary table, but they would have their own, not a shared table like a permanent one that is in the database.
Again the use of persistent connections would be a the heart of this I would think.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
