RE: [PHP-WIN] MySQL / PHP - possible to run many sql statements in the same execution?

From: 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

« previous php.windows (#13327) next »