Re: Transaction over persistent connection problem
| From: | Manuel Lemos | Date: | Wed, 27 Apr 2005 17:19:34 +0000 |
| Subject: | Re: Transaction over persistent connection problem | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39298@lists.php.net to get a copy of this message | ||
Hello,
on 04/27/2005 11:49 AM Oskar said the following:
Ok. So the idea of splitting one transaction into two steps of a script is wrong?Yes, it is not possible to achive that. What happens is that first access to script is handled by one Web server process or thread and you cannot assure that the second access will be handled by the same Web process or server to finish the same transaction that was started. Furthermore, you should never leave a transaction open that you cannot guarantee that it will finished in a very short notice, otherwise it may block the access to the whole database forever. -- Regards, Manuel Lemos PHP Classes - Free ready to use OOP components written in PHP http://www.phpclasses.org/ PHP Reviews - Reviews of PHP books and other products http://www.phpclasses.org/reviews/ Metastorage - Data object relational mapping layer generator http://www.meta-language.net/metastorage.html