Re: MySQL and transactions

["Jeremy D. Zawodny" <jzawodn@xxxxxxxxxxxxx>]

On Wed, Dec 27, 2000 at 11:14:40PM -0800, Ryan Worley wrote:

> What is the current stance on using transactions in MySQL?  BDB
> tables?

Yes. If you need transactions use BDB tables. They seem to be nearly
stable now from the reports on this list.

> LOCK TABLES (and pray)?

Thats a performance killer if you need much concurrency.

> I've been researching both methods but they both seem to have their
> fair share of drawbacks.

There are always tradeoffs. :-(

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@xxxxxxxxxxxxx>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878    Fax: (408) 530-5454
Cell: (408) 439-9951

-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60338@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php