Re: Web application?
| From: | Mark Charette | Date: | Sat, 14 Jul 2001 18:17:38 +0000 |
| Subject: | Re: Web application? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-57897@lists.php.net to get a copy of this message | ||
From: "Christopher Ostmo" <tech@appideas.com>
> 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.