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. ~Mike Foss _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
