On Aug 22, 2010, at 4:37 AM, Wirrunna wrote: > > Couldn't resist trying this out. > Ran a clear & rescan on my workstation, then set cache size to 100000 > (andyg is always conservative with his settings) and ran the clear and > rescan again for a 16 minute reduction in elapsed time. Cut & paste > attached. Win XP. > A google for SQLite optimization brought up this rather old but > interesting document - > http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html > It would be good to be able way to get the output of a pragma command > to query the current value, then us tinkerers could check if > 'synchronous' is set to Off, Normal or Full.
Default pragmas are: PRAGMA synchronous = OFF PRAGMA journal_mode = MEMORY PRAGMA foreign_keys = ON PRAGMA locking_mode = EXCLUSIVE With the highmem pref enabled you also get: PRAGMA cache_size = 20000 (default is 2000) PRAGMA temp_store = MEMORY _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
