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

You could also use semaphores/locks :) --- Scott Hurring Systems Programmer EAC Corporation ScottH@eac.com Voice: 201-462-2149 Fax: 201-288-1515 > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@lumc.nl] > Sent: Friday, April 26, 2002 7:22 AM > To: Matt Babineau > Cc: 'Php-Win (E-mail)' > Subject: RE: [PHP-WIN] MySQL / PHP - possible to run many sql > statements > in the same execution? > > > > 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 > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >