vagskal;563512 Wrote:
>
> Attached is the last part of the debug level logging log. I have set
> CustomTag to scan these tags ORIGYEAR,YEAR,TYER,STYLE,MOOD,THEME and do
> this tag mapping TRACKYEAR=oneof ORIGYEAR|YEAR,ALBUMYEAR=oneof
> TYER|YEAR. It seems that CustomTag is looking up the value for all
> tags.
>
If you look in the log for rows which message part starts with
"Scanning track: ", you can look at the timestamps to see how long it
takes to scan a single track. Based on this you can calculate the total
scanning time by multiplying it with the total number of tracks.
I'm not sure if the log contained all entries between two "Scanning
track: " rows but if it did it means that a single track takes about
2/100 of a second, which means that it should be able to scan about 50
tracks per second if my math is correct. With the 115024 tracks which
your database seems to contain this should result in a scanning time
around 40 minutes plus a few minutes for the refresh and delete
operations in the beginning.
So based on this it sounds like it should have been finished a long
time ago.
Try searching in the log for "Performing rescan" or "Performing module
rescan", maybe there is some cycle so it continues to run the scanning
multiple times ?
Custom Tag scanning module reads all tracks and print their values when
debug logging is enabled, it will only store the tags which you have
configured it to store.
vagskal;563512 Wrote:
>
> The optimized MySQL my.tt is not loaded at the moment (there was an
> update of SBS 7.5.2 and I forgot to replace that file after the
> update). Win XP is set to prefer services over programs.
>
I suspect this might cause part of the differences, the optimized my.tt
usually gives big improvements in larger libraries on computers with lot
of memory. As an example, it might mean that the scanning itself is
pretty fast but there is some of the SQL statements executed in the
beginning or end that takes a lot of time without the optimized my.tt
file.
Possibly the tag mapping logic might also cause some performance
problems but I suspect it doesn't as it's only perl code and no extra
data access.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
