Here are the results of the first test with a 260,000 file library. The
Flac files are all 10 seconds of silence, then tagged exactly as my
real Flac library. What I did to generate the library was to duplicate
the albums in my 32.7k file library multiple times, changing the album
and folder name each time by appending a number 01, 02, etc. All of the
tagging is identical otherwise. Covers were also copied to the
library's folders.
These times were from the initial scans launched by starting up the
server with an empty cache folder and (in the case of MySQL) an empty
database. Both scans probably benefited from system caching, since I
ran them soon after generating the library itself. I ran the MySQL scan
first, so the SQLite scan, if anything, would have benefited more from
caching.
Instead of giving total scan time, I'll list the time it took for the
'Discovering Files' pass and the 'Scanning new files' pass at 1/4, 1/2
and all the way through the library. This is mostly because the MySQL
scan must be aborted during the precaching of artwork, so a total time
can't be had, but it also shows how both slow down as the library
database grows, but SQLite it much more affected.
Code:
--------------------
MySQL
------------------------------------
Discovering files 1:59
Scanning new @ 65k files 5:40
Scanning new @ 130k files 12:17
Scanning new @ 260k files 26:12
SQLite
------------------------------------
Discovering files 1:40
Scanning new @ 65k files 9:08
Scanning new @ 130k files 26:49
Scanning new @ 260k files 1:12:17
--------------------
Second run, this time running full scans from the Basic Settings page
in the web ui. Similar results.
Code:
--------------------
MySQL
------------------------------------
Scanning new @ 260k files 27:11
SQLite
------------------------------------
Scanning new @ 260k files 1:15:41
--------------------
I should note that the above results do not jive with what I see when
scanning my 32.7k file library, where SQLite is faster.
--
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
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss
