Re: Re: SQLite vs CDB_File vs BerkeleyDB

Otherwise SQLite does a fflush on every row, making it much slower ;-)

The option is only relevant if you're worried about data integrity during a filesystem crash.

Comment on Re: Re: SQLite vs CDB_File vs BerkeleyDB

Replies are listed 'Best First'.
Re: Re: Re: SQLite vs CDB_File vs BerkeleyDB by dws (Chancellor) on Mar 19, 2002 at 19:50 UTC
Otherwise SQLite does a fflush on every row, making it much slower ;-) Uh... That sounds like you're defeating `AutoCommit => 1`, which would make this a misleading benchmark.	[reply] [d/l]
Re: Re: Re: Re: SQLite vs CDB_File vs BerkeleyDB by Matts (Deacon) on Mar 19, 2002 at 20:51 UTC
Not at all. None of the others were doing fflush per row, so why should SQLite suffer?	[reply]
Re: Re: Re: Re: Re: SQLite vs CDB_File vs BerkeleyDB by dws (Chancellor) on Mar 19, 2002 at 21:12 UTC
None of the others were doing fflush per row, so why should SQLite suffer? Then why invoke the pragma on `$dbh` and not `$dbh2` (or is does the pragma have global effect)?	[reply] [d/l] [select]
Re: Re: Re: Re: Re: Re: SQLite vs CDB_File vs BerkeleyDB by Matts (Deacon) on Mar 19, 2002 at 22:23 UTC