A few questions that are my application specific that is an embedded 

I have two databases, the first one is a fixed size configuration database 
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

Reply via email to