-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/25/2011 07:04 PM, Frank Chang wrote: > While writing the records to to the sqlite database we do a commit every > 10000 records. >We think we understand that we also need to do a sqlite pragma wal_checkpoint everytime >we do a sqlite database commit.
It isn't clear if you are talking about initial population of the database or working later on. If you do the above during initial population then what exactly is the point of using WAL? You are just doing the same thing as the regular journal but in a roundabout way! If you are talking about regular working later on then what bit of your testing led you to believe the defaults were not ok? Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk3dv70ACgkQmOOfHg372QRvtQCfW0o/pg/vMKJJ91O0k0BEbW7Q Q1UAoJuUkSdNQR7By/O7AfchVJ1si32P =/YKj -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
