Dominique Devienne wrote: > My assumption > was that after the zeroblob(N), there was enough room in the main DBs > pages, such that the subsequent blob open+write+close did not need to > generate any "page churn" (i.e. journal activity) and could write directly > to the pages created on initial insert.
It does write to the same pages, but those pages must be copied to the rollback journal so that they can be restored if the transaction is rolled back. (Or are the two passes inside the same transaction?) Don't insert the zero blobs in the first pass; this still rewrites all rows, but there is less data that might need to be rolled back. Consider moving the blobs to a separate table. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users