Hi All, My application uses temporary tables that can become quite big (>300MB), so it makes sense to me to change the page size and cache size with pragma statements.
The docs say "The default suggested cache size is 2000 pages" and "The normal configuration for SQLite running on workstations is for atomic write to be disabled, for the maximum page size to be set to 65536, for SQLITE_DEFAULT_PAGE_SIZE to be 1024, and for the maximum default page size to be set to 8192." So I set my page size to 8192. That means the suggested cache size is still only 16MB. If I increase my cache size to 20 000 pages I see a lot more that 10x increase in memory use and also very slow connection close, presumably due to deallocation of page memory. Should I increase page size instead? What do you guys do when it is OK for SQLite to chew as much memory as you have? Also, does it make sense to change the page size only for the temp database? "pragma temp.page_size=65536" ? Regards, Paul. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
