>>>>> On Thu, 21 Mar 2002 00:40:24 +0100, Bas A.Schulte <[EMAIL PROTECTED]> said:
BAS> To handle a large number of concurrent transactions in a
BAS> transaction-safe environment without me having to worry too much about
BAS> concurrency issues and referential integrity I will slowly move to
BAS> Oracle. $dbh->do('LOCK TABLE USER, INSTANCE, APP_DATA') just plain
BAS> sucks unless you want to create a very large distributed *single-user*
BAS> system running on multiple machines.
Without changing SQL backend you can have transactions with
MySQL. Just use InnoDB table type. It is faster than default table
type for read/write intensive applications because it doesn't lock
whole tables but provides Oracle style row-level locking.
--
o Ilya Martynov => http://martynov.org/ o
o TIV.net => http://tiv.net/ o
