>> 3) Similar to the original question, if you set temp_store = 2 (memory) and >> there isn't enough memory for the table what happens?
>By 'memory' that web page is referring to whatever your operating system thinks is memory. So the >same thing happens as would happen to any application which tries to use a lot of memory: the virtual >memory mechanism kicks in and memory is swapped to and from disk. Thanks Simon but is that to say sqlite attempts to increase the temp table's page cache size beyond the size it was originally allotted? If the answer to that is yes then that also answers question 2). -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
