Re: [sqlite] InnoDB Transactions

2005-05-16 Thread Mrs. Brisby
On Sun, 2005-05-15 at 19:48 -0700, Dan Kennedy wrote: > Anyone have a quick summary of InnoDB algorithm for comparison? I > suspect whatever trick they use won't work with SQLite because > there is no server process, but it could be interesting anyway. There are several ways the extra fsync() migh

Re: [sqlite] InnoDB Transactions

2005-05-15 Thread Dan Kennedy
--- Ludvig Strigeus <[EMAIL PROTECTED]> wrote: > Quote: > > InnoDB must flush the log to disk at each transaction commit, if that > transaction made modifications to the database. Since the rotation speed of > a disk is typically at most 167 revolutions/second, that constrains the > number of

[sqlite] InnoDB Transactions

2005-05-15 Thread Ludvig Strigeus
Quote: InnoDB must flush the log to disk at each transaction commit, if that transaction made modifications to the database. Since the rotation speed of a disk is typically at most 167 revolutions/second, that constrains the number of commits to the same 167/second if the disk does not fool the