Clemens, We have 8GB of memory which is the most our VPS provider allows. We?d like 32GB but its not an option for us. Our desktops have more than that, but the VPS provider is reasonably priced :)
We hadn?t considered the WAL mode, my conclusion is that a simple change to our workflow is actually simpler, we stop the database updates for 15 mins out of hours, cp and then restart. Its not ideal but we?re not running a nuclear power station or a 24/7 medical facility. Users *may* not get traffic updates for 15 mins at 03:00 in the morning. The world will keep spinning. Rob On 4 May 2016, at 12:58, Clemens Ladisch wrote: > Rob Willett wrote: >> We?re trying to backup a 10GB live running database >> ?as-fast-as-we- >> possibly-can? without stopping updates coming in. > > How much memory do you have? I guess you can't simply read the entire > database file to force it into the file cache? > > In WAL mode, a writer does not block readers. You have to decide > whether you can live with its restrictions: > http://www.sqlite.org/wal.html > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users