JJZolx;425536 Wrote: > One thing I've noticed is that subsequent scans with SQLite, even if > they're clear/rescans, are much faster than the first scan. I'm guessing > that this may be because when a 'clear' is done, the SQLite database > file remains the same size (actually, MySQL InnoDB databases operate the > same way), so the SQLite library file itself doesn't need to grow when > rebuilding the database. >
I see the same - a very basic comparison is here: http://forums.slimdevices.com/showthread.php?p=423983&highlight=12#post423983 -- Siduhe Who am I on 'LAST.FM' (http://www.last.fm/user/siduhe)? "-Siduhe Loved Tracks radio got the thumbs up. Feedback included: yeah, it's good... got the odd dodgy track tho...-" (c) 'ModelCitizen' (http://www.last.fm/user/Modelcitizen) ------------------------------------------------------------------------ Siduhe's Profile: http://forums.slimdevices.com/member.php?userid=723 View this thread: http://forums.slimdevices.com/showthread.php?t=63421 _______________________________________________ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta