On Mon, 2 Sep 2013 21:45:04 -0700 Michael Foss <foss.m...@gmail.com> wrote:
> You are right that new data is usually more than a single INSERT. I will > try out your suggestion of opening and closing the database file outside of > each transaction. > > I am also going to look into WAL journalling mode since I am only writing > data to the disk in the mode that my embedded system operates. I am not yet > sure whether it is a better choice with respect to random power loss. If you switch to wal mode, setting pragma wal_autocheckpointing to low value may help you. Default is 1000, in a similar environment (embedded device that reads data from external analogic devices) we setted it to 1. > ~Mike Foss --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users