On 21 Dec 2017, at 2:15pm, curmudgeon <tam118...@hotmail.com> wrote:
> Can someone tell me, if I create a temporary table does is its 'separate > cache' created within the cache_size cache or is it completely separate from > that? According to the documentation you quoted, "Each temporary table and index is given its own page cache" every temporary table gets its own cache. Each cache can grow to a maximum size of SQLITE_DEFAULT_TEMP_CACHE_SIZE . Be aware that you cannot magically create more RAM in your computer by defining enough temporary tables. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users