Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?
[email protected] (Lester Caine)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
Sara Leavitt wrote: > So I can see that using two connections for updating might get out of > synch; however, mixing the connections should be OK for a series of > SELECT queries on the read-only side of the application, right? Yes - if you are only reading already stored data there should not be a problem. > -Sara > > Lester Caine wrote: >> 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