On 30 Aug 2010, at 2:34pm, Pankaj Chawla wrote: > Yes, I guess I am trying to figure out which poison to pick :-) > So here is what I need: > > 1. Lowest possible writes to the NAND. > 2. Highest possible database reliability in situations of power > outage/reboots > since the device is unmonitored. > 3. Am ok with losing 2-5 minutes of data as long as 2 is not compromised.
Do not mess with any PRAGMAs or compilation options at all. Do all your operations with a database held in :memory: http://www.sqlite.org/inmemorydb.html Every two minutes (background timer ?), update the database held in NAND, using one big transaction. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
