Hi, i have something to add: SQLITE_DEFAULT_TEMP_CACHE_SIZE is not used anywhere in the sqlite.c file of the amalgamationand the comment above seems to be incomplete. Is this intended?
Martin Am 02.02.2011 13:38, schrieb Martin Engelschalk: > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- *Codeswift GmbH * Kräutlerweg 20a A-5020 Salzburg Tel: +49 (0) 8662 / 494330 Mob: +49 (0) 171 / 4487687 Fax: +49 (0) 3212 / 1001404 engelsch...@codeswift.com www.codeswift.com / www.swiftcash.at Codeswift Professional IT Services GmbH Firmenbuch-Nr. FN 202820s UID-Nr. ATU 50576309 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users