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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
