On 19 Dec 2017, at 9:33am, curmudgeon <tam118...@hotmail.com> wrote:
> Running the same tests again using > an actual table (TEMP keyword omitted) shows the in memory INSERT (and > DELETE) to be twice as fast on the database loaded into memory compared to > when it's accessed from the SSD.The timings in the original tests were > similar to the in memory database suggesting the TEMP table for those tests > were created in memory regardless of whether the actual database was loaded > in memory or not. I can't see any documentation suggesting that though. > Could someone clarify? See section 3 of <https://sqlite.org/tempfiles.html> A working assumption is that temporary files are created in memory and only if they get big enough to trouble virtual memory do they require disk access. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users