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.
+-------------------------------------------------------------------+ |Filename: Scanner test.zip | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=10512| +-------------------------------------------------------------------+ -- Wirrunna A camel is a racehorse designed by a committee. ------------------------------------------------------------------------ Wirrunna's Profile: http://forums.slimdevices.com/member.php?userid=3225 View this thread: http://forums.slimdevices.com/showthread.php?t=81310 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
