note 92614 deleted from features.persistent-connections by thiago
| From: | thiago@php.net | Date: | Fri, 31 Jul 2009 13:05:27 +0000 |
| Subject: | note 92614 deleted from features.persistent-connections by thiago | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-158960@lists.php.net to get a copy of this message | ||
Note Submitter: v13 at v13 dot gr
----
As a reply to "ynzhang from lakeheadu canada": temporary views/tables only live inside a
transaction block and are only visible there. There are two reasons for this not to work as he
describes:
(a) Because each request may end up running by a different server process, thus using a different
connection
(b) All transaction will (should) be commited or rolled-back when a script is ended, unless there is
a "transcation leak" in the script (which is bad). Since a temp only lives inside a
transaction, this commit/rollback will auto-remove the temp table.
All the above are explained in the document.