View Single Post

  #2 (permalink)  
Old 10-27-2003
Cpt John W. Holmes
 
Posts: n/a
Default Re: [PHP] php temp table question (for mysql)

From: "Larry Brown" <larry.brown@dimensionnetworks.com>

> Does anyone know whether the use of persistent connections with php will
> allow a temp table created by a script to linger around


No, the table will still be removed at the end of the script whether you use
persistant connections or not.

> and cause a problem
> with the next execution of the script when it tries to create the temp

table

Temporary tables are unique for that specific question. So you can have the
same script creating the "same" temporary table and 100 people hit it
without issues. Each script creates it's own temporary table with a unique
name that only that connection has access to.

---John Holmes...
Reply With Quote