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. Regards, Clemens _______________________________________________ sqlite-users mailing list email@example.com http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users