From: "Christopher Ostmo" <[EMAIL PROTECTED]>
> The lack of transactions can easily be overcome by proper programming
> logic.

That, unfortunately, is totally untrue if there's the possibility of more
than one person manipulating data at one time on tables.

The "old fashioned way" of locking all involved tables for read & write,
trying to perform a sequence of operations and undoing the operations if
there's a failure anywhere - is effectively a single-threaded transaction.
Until fairly recently that was the only way of doing transactions in MySQL.

Re: innodb - I tried setting up a 5 Gb database and gave up after 5 hours of
innodb initializing the db disk. Went back to the MySQL defaults. YMMV.


-- 
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]

Reply via email to