A few questions that are my application specific that is an embedded application.
I have two databases, the first one is a fixed size configuration database where all writes are UPDATES, and the database does not get that many writes. Does this mean that because of WAL the database itself will not get updated and changes will be residing in WAL for a very long time due to lack of traffic? The second is an archive database that is written to once a second, and once a month (size grows to 335MB), the database is closed, renamed, a template database is copied over, and the process starts again. Does this mean that I have to worry about renaming the WAL file as well now? Thanks in advance. _______________________________________________ sqlite-users mailing list email@example.com http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users