Maybe this could be added as a "Feature request" to open_v2 ? Add,
#define SQLITE_OPEN_OMIT_JOURNAL 0x00008000 Test this flag and set the omit_journal parameter to Btree factory... To cause sqlite to omit journal creation. Obviously this has serious impact to a databases recoverability. But when the Durability component of ACID is not needed it should provide a nice performance boost! In my particular case, I have many small db files that have data. These are "batched" into a db file. If the process fails the in progress batch will simply be overwritten and re-created. Hence it is an all or none approach and does not need any recoverability. Thanks, Ken _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
