These are with SQLITE3's memmap turned off (SQLITE_DEFAULT_MMAP_SIZE 0). I set the MAX_SIZE to 0 as well and it made no difference.
Windows is memmapping the file by itself. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of David Raymond >Sent: Monday, 18 June, 2018 07:10 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >I haven't grasped all the fancy memory talk that's been going on >here, but I have one request. Would you try the slowdown tests with a >SQLite version compiled with... >SQLITE_DEFAULT_MMAP_SIZE=0 >SQLITE_MAX_MMAP_SIZE=0 >...and see if anything changes? I started compiling with those >options after some similar speed issues "back when" and things seem >to have cleared up since then. I'm curious if it's because I added >that or if it's just a coincidence. >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users