RE: [PHP-WIN] MySQL / PHP - possible to run many sql statements in the same execution?
| From: | HKG) | Date: | Fri, 26 Apr 2002 11:22:14 +0000 |
| Subject: | RE: [PHP-WIN] MySQL / PHP - possible to run many sql statements in the same execution? | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-13327@lists.php.net to get a copy of this message | ||
> What I would need to do here is either lump all the queryioes into one
> SQL execution or lock the PHP code so it is single threaded like this:
I understand this as that you are trying to deal with the (in)famous
readers&writer problem here? There is a basic technique to deal with
this, and it is called an "atomic action".
In an RDBMS you can perform an atomic action by starting up a transacation
with the highest isolation level. However, in most case you don't need to be
_that_ much "atomic", and a lower transaction lever might very well be optimal
solution most purposes (unnecessary high isolation levels degrades performance.)
//Anders - idiot