Re: Not so good transaction support

2001-08-09 Thread Sinisa Milivojevic
What you are trying to perform is doable with InnoDB table handler. Unlike BDB, InnoDB has multi-versioning and consistent reads. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime

Re: Not so good transaction support

2001-08-09 Thread Michael T. Babcock
1. Please explain the above in detail. It depends on the type of table you're using. If you're using a table type that only supports table-level locking, then each transaction is isolated by being suspended until the previous transaction is done. This is slower if you do a lot of longer

Not so good transaction support

2001-08-08 Thread
Hi. I downloaded mysql 3.23.40 from www.mysql.com. This site announces that this mysql version supports transaction which was not supported in older mysql. I was so happy to find that. So I tested that support. The case was following. I launched two mysql - one in A terminal window and other in