Sara Leavitt wrote:
Hi Lester,
Our application is not using php transactions (e.g., COMMIT, ROLLBACK
etc.), so I think we are safe there. Are you saying that even if both
the mysql_pconnect and PDO connection are persistent that they will be
completely separate? (Havn't had a chance to test this empirically just
yet.)
Yes ... I'm not totally sure about how MySQL works by default, but having
'committed' data on one connection, one would need to refresh the other
connection possibly to see that data. Firebird is a lot more manageable on
transaction control, and basically data entered on on connection will not be
visible on the other until properly committed. Having that activity hidden in
the drivers can lead to a little 'confusion' as to what state data is actually
in ....
Even just opening two connections via the MySQL driver will have the same effect.
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
