erland wrote: > 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. I'd be happy to try an Alpha test if it would help. If you wanted to supply me with a different 'create tables' script I could swap in, and a separate create indexes script to run after, I could probably manage to run that myself.
For me I'd be happy not to attempt to play music during the custom scan because it has never worked well in the past, stopping and starting and being generally impossible to listen to. It may be that with a vacuumed system it would work better, but I haven't tried. LMS 7.9 on VortexBox Midi running Xubuntu 14.04, FLACs 16->24 bit, 44.1->192kbps. Wired Touch + EDO, coax to Musical Fidelity M1 CLiC. Wireless Xubuntu 14.04 laptop controls LMS via Chromium. Meridian Explorer USB DAC to listen via Squeezelite on Vortexbox & other PCs as required. Spare Touch in loft. ------------------------------------------------------------------------ PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=101469 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
