This also troubles me i have read and read the docs on this. It seems that Lock tables
prevents other threads interfering with your transaction your inserts will not be
compromised by another thread deleting or updating data inconsistent with your SQL. The
snag for me is that all obscure input from the user and every other eventuality has to
be
trapped prior to avoid sending dud SQL to MySQL, other wise the inserts/updates will
fail.
The TO DO list talks about atomic inserts/updates which would solve my problems ie they
all happen or all do NOT happen. If MySQL can do this then I don't care about
rollback. I
would dearly like to use the fast tables rather than compromise speed using DBD tables
but
as I see it we are stuck with them or Postgres until the atomic updates code is
completed.
Be interested to know if anyone has got atomic updates sorted.
Phil Daintree
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]