Hi all, I had to recognise that our data-transforming (read: heavily inserting) procedures had a massive drop in performance with 3.7. Some investigation showed that this is related to "pager_write_pagelist" where a hint to an estimated target filesize is given to the filesystem, which on Windows translates to a winTruncate. This in turn causes a low-level-flush of file metadata and performance drops to nil. Is the setting of the file size really needed here or can we safely drop it? Dropping it seems to work for ourselves,
Regards, Gerd _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
