Ticket: 3007 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! I did a quick one off on the code hard coding the omitFlag to one for the btreeFactory call. All appeared ok, but I didn't run the regression testing, I'm guessing many of these would fail due to the lack of journalling. 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 for considering this! Ken _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users