Hello Richard, Thanks again.
Wednesday, November 30, 2011, 5:37:32 PM, you wrote: RH> On Wed, Nov 30, 2011 at 5:31 PM, Teg <t...@djii.com> wrote: >> Since we're on this topic.... >> >> If I open a 30 GB DB file, then attach a new empty DB and then >> select/insert all the data from the full DB to the empty one, the WAL >> file grows to 4 times the size of the source file. Why is that? >> >> I don't believe I use any manual checkpointing. Just let WAL do it's >> thing. >> RH> The WAL file won't get so big if you break the transfer up into multiple RH> transactions. RH> Or, you can temporarily disable WAL mode for certain unusual operations RH> (like this one) for which is not well suited. >> >> >> >> >> >> Wednesday, November 30, 2011, 4:36:00 PM, you wrote: >> >> >> SS> On 30 Nov 2011, at 7:01pm, Richard Hipp wrote: >> >> >> The wal file persists until the last connection to the database closes, >> >> then the wal file is deleted. >> >> SS> Actually this is the key to a lot of questions about this. If >> SS> your WAL file is taking up too much space, quit and restart your >> SS> app. Or have your app close and reopen the database connection. >> >> SS> It's a little more complicated in multi-user or multi-process >> situations, of course. >> >> SS> Simon. >> SS> _______________________________________________ >> SS> sqlite-users mailing list >> SS> sqlite-users@sqlite.org >> SS> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> >> >> -- >> Best regards, >> Teg mailto:t...@djii.com >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
