On 19 Dec 2017, at 9:22pm, curmudgeon <tam118...@hotmail.com> wrote: > Thanks Keith. So sqlite does look to increase the temp table's cache size if > it's not big enough?
No. Memory allocated to that cache is memory which can’t be used by anything else. There’s probably a far better use for that memory than using it for one obscure SQLite table. If the table gets so big it can’t all fit into the cache allocated to it, it’s written to disk instead. Of course, it’s written to disk using OS calls, so there’s a chance that the OS will decide that that data should be cached. Your ideas portray a world where a computer really has infinite RAM, if only it would just allocate it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users