Hi list, I have a problem getting PRAGMA temp_store = MEMORY to work.
I do a select joining two tables with an order by for which no index esists. This selects all the data in my database, 1 million records. The database size is 196 MB. When using version 3.2.5 (the amalgamation, no special pragmas or #defines), my executable consumes 345 MBs of memory, does not write any temporary files, and finishes in about 100 seconds. With version 3.7.5, downloaded today, i have to do some things to get sqlite to work like before. I want to avoid temporary files, which are created by default for the temporary index. Even if i set PRAGMA temp_store = MEMORY after opening the database, a temporary file gets written, and the memory usage is 72 MB. I read the docs and compiled the amalgamation with various values of SQLITE_DEFAULT_TEMP_CACHE_SIZE, and after opening the file set PRAGMA cache_size to different values. However, even if memory usage rises up to 318 MB, a temorary file is written which is larger than the database itself. This is on Windows XP, with 1 GB of freee memory. What am i missing? Thank you, Martin _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
