Ok, the new library has been generated: 1,000,000 tracks (Why mess
around, right?)

I'm scanning it now with a 7.6.1 server running SQLite. I'm not
certain, but already I may be seeing something. Discovery of the 1M
files took just 9:28. Scanning the first 25k tracks took about 10
minutes. Now, at 50k tracks, the time for the scanning new files pass
is over 42 minutes. Much slower per track than for my 33k track
library, which takes less than 12 minutes total to scan.

If it keeps degrading like this as the database grows larger, it's
going to take a _very_ long time to scan the whole library. Maybe
longer than I have the patience for.

It will be interesting to see how well SBS with MySQL handles scanning
the same library. I may also have to scale back the test to something
like 250k tracks.


+-------------------------------------------------------------------+
|Filename: 2011-08-06_210334.jpg                                    |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=12215|
+-------------------------------------------------------------------+

-- 
JJZolx
------------------------------------------------------------------------
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=89391

_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss

Reply via email to