Wirrunna;571043 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.
I would expect the highmem settings to help more during everyday use and browsing rather than scanning. Scanning is mostly write traffic which is not really going to make use of the extra cache space. Browsing is almost all read traffic. -- andyg ------------------------------------------------------------------------ andyg's Profile: http://forums.slimdevices.com/member.php?userid=3292 View this thread: http://forums.slimdevices.com/showthread.php?t=81310 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
