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