PasTim wrote:
>
> The Custom Scan 'info' output is below. It still took almost exactly
> 1.5 hours. I include this in case Erland is interested.
>
Thanks!
Looks like 1 hour and 21 minutes were spent in the Custom Tag scanning
process which will iterate through all tracks in the database and:
- do a select towards tracks table for each track
- do a number of inserts into customscan_track_attributes table for each
track (one for each tag you configured it to scan)
- commit after each track has been processed
The customscan_track_attributes table have a number of indexes so if the
performance is limited by the database I suspect it might be index
related.
In this case it could be better to disable the index during the
scanning, at least in a large library, and enable them after the
scanning process has finished. I need to experiment a bit and I think I
also need to add some log point so we are sure the time is spend in the
database and not in file I/O or caused by background scheduler running
slowly to allow music playback during scanning. Custom Scan runs in the
main LMS process and not in the scanner process as the main LMS scanner
does.
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland).
If you like to encourage future presence on this forum and/or third
party plugin/applet development, 'consider purchasing some plugins'
(http://license.isaksson.info))
*Interested in the future of music streaming ? 'ickStream - A world of
music at your fingertips'
(http://forums.slimdevices.com/showthread.php?98467-Pre-Announcement-ickStream&p=743516)*.
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=101469
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
