Re: Cost of transactions, and alternatives

2001-04-26 Thread Joseph Bueno
[EMAIL PROTECTED] wrote: > > Hello, MySQL Experts, Hello, > [.} > > Alternatively, is there any way I can safely generate a unique id without > creating the master row? > The I could put the slave rows in before I create the master row, and I > wouldn't have a problem. You can use one au

Re: Cost of transactions, and alternatives

2001-04-26 Thread Heikki Tuuri
Hi! InnoDB tables are often even faster than MyISAM tables for read access. In updates and inserts it depends on whether you flush the log to disk at a commit. A disk write takes some 10 ms. InnoDB does not lock the rows it reads (a consistent read). Therefore the writes do not block reads. Rega

Re: Cost of transactions, and alternatives

2001-04-26 Thread Paul DuBois
On Thu, Apr 26, 2001 at 04:31:40PM +0100, [EMAIL PROTECTED] wrote: > Hello, MySQL Experts, > > I wonder if you could give me some advice on a database design problem. > > I have a table which will have many more reads than writes (between 10 and > 100 times). I wish to make > updates to that tab