Eric Grange wrote:
> Ran some tests with variations of Clemens's backup exemple, and adding
>         sqlite3_exec(src, "PRAGMA cache_size=1", NULL, NULL, NULL);
>         sqlite3_exec(dst, "PRAGMA cache_size=1", NULL, NULL, NULL);
> seems to provide the best performance [...]
> While the effect of synchronous=OFF on the destination backup db was
> something I expected, the cache_size of 1 was not.
> Using large cache_size had a detrimental effect, both on source or
> destination, between cache_size 1 and the default of SQLite (-2000) there
> is a 20% difference in performance during backup.

A backup simply copies all pages.  It accesses each page once, so all
cache lookups will fail.

sqlite-users mailing list

Reply via email to