Re: [sqlite] poor insert performance with 3.7/Windows

2010-07-26 Thread Shane Harrelson
I've not seen the performance degradation you've reported here in my testing. If you could provide any more details that would help in reproducing this, it would be appreciated. And yes, you can safely modify the SQLITE_FCNTL_SIZE_HINT in os_win.c to be a "no-op" in the same way as os_unix.c.

[sqlite] poor insert performance with 3.7/Windows

2010-07-24 Thread GB
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