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
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
