Thanks for your help! Especially the comment about cache size helped a lot. When I reduced the cache size to about 100 pages I actually get it do the writing incrementally in multiple sqlite3_backup_step() calls. With bit more finetuning I think it will be ok.
I also had unrelated problem of using same database handle for backup and some other things at the same time which understandably caused additional blocking. After these changes it is now performing very well. Thanks! Toni Tammisalo ttamm...@iki.fi _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
