WAL mode still writes the journal to disk. Perhaps combining this with SQLITE_TEMP_STORE=3 would be the best of all worlds? Then his current situation of writing a 2-minute transaction should work just fine and minimize the # of writes. Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp Sent: Mon 8/30/2010 7:20 AM To: General Discussion of SQLite Database Subject: EXTERNAL:Re: [sqlite] Sqlite on NAND flash devices... Use WAL mode. Set PRAGMA synchronous=NORMAL. Do transactions that last 2 minutes each, starting a new transaction after each COMMIT. Run checkpoints in a background thread.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
