I also added the following pragmas for SQLite when highmem mode is enabled:
Code: -------------------- PRAGMA cache_size = 20000; PRAGMA temp_store = MEMORY; -------------------- This should let the database use up to 20MB for page cache and store temporary files in memory (used by sorts, joins, etc) -- andyg ------------------------------------------------------------------------ andyg's Profile: http://forums.slimdevices.com/member.php?userid=3292 View this thread: http://forums.slimdevices.com/showthread.php?t=70371 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss