in reply to SQLite vs CDB_File vs BerkeleyDB

Excellent!

One question. Why   $dbh->do('PRAGMA default_synchronous = off'); in the default (commit after each insert) case? Is this not something that could be hidden beneath the options on the connect?

Replies are listed 'Best First'.
Re: Re: SQLite vs CDB_File vs BerkeleyDB
by Matts (Deacon) on Mar 19, 2002 at 19:45 UTC
    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.

[reply]
      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]
        Not at all. None of the others were doing fflush per row, so why should SQLite suffer?
[reply]

In Section Meditations