Persistent Links and Temporary Tables
| From: | Robert Gormley | Date: | Sat, 15 Sep 2001 06:19:11 +0000 |
| Subject: | Persistent Links and Temporary Tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12470@lists.php.net to get a copy of this message | ||
Hi,
Is anyone able to briefly explain to me how the use of temporary tables by MySQL is affected by PHPs persistent connections?
From my reading of MySQL temp tables are deleted when the current connection is closed, but that might not be for quite a long time with a persistent connection... also, how does this affect concurrency of temp table creation?
Robert
Robert Gormley
robert@seabreeze.asn.au
http://seabreeze.asn.au/