--- "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> On Mon, Jan 09, 2006 at 06:47:04PM +0100, Eduardo wrote: > > of transactions per second. But because each transaction requires at > > least two revolutions of the disk platter, SQLite is limited to about > > Why does a transaction commit require two seperate writes? > -- > Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > The short version: The first write operation writes the parts of the database that are about to be overwritten to the journal file. If something goes wrong during the second write, the journal file will be used to restore the database to it's previous state. The second write is the one that actually modifies the database file. __________________________________________ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com
