audiomuze;639423 Wrote: > I've been running 7.6.x for as many months as it's been a beta. I've no > idea what development work is still going into it, but there remain > serious issues with the scanner logic where rescanning is concerned. I > have a large library and in general terms when adding a few albums or > making a small number of changes to existing albums the rescan works > well. After seeing the recent thread regarding Various Artists I > decided to revisit tagging of all my compilation albums and as a result > moved them all to a sub folder called VA/ in the library's directory > tree. This made dealing with all compilation albums pretty simple in > that I could point a tag editor to a single folder.
That's how I've always kept my compilations. And you're right, it does make changing the way you tag all of them very easy. > When I was done I launched an update scan - this resulted in around > 19,000 tracks no longer being present where they were previously housed > (and would therefore be deleted from the DB), and of course the same > number of "new" tracks with revised tags being found in the VA/ > location. That's a pretty big library change. I wouldn't run a new & changed scan, but would run a full scan instead. > Now, to my mind deleting records from a database should be a pretty > quick exercise, yet the rescan routine goes into the deleting of > records and stays there for over an hour before moving on to doing the > rest of its business, and after a few hours we're still nowhere. Surely > it cannot take hours to make these changes? I could easily see this bogging down the scanner. The way the database is organized could make it extremely inefficient (and the database is essentially unchanged from 7.5). The Squeezebox Server database is not highly normalized, and there are quite a few dependencies that exist between tables. It takes a lot of work when deleting even a single track to be sure that the albums, genres, years, and contributors tables remain free of anomalies. For example: Delete the following album Artist: Illinois Jacquet Album: The Blues Year: 1969 Genre: Jazz Delete a single track and you then have to run a database query to see whether tracks from the album 'The Blues' still exist. If not, delete the album from the albums table. Then see whether the contributory 'Illinois Jacquet' still exists, and if not, delete it from contributors. Same thing for the year and the genre. If this is done for every single track, and you're deleting thousands of tracks, it gets very time consuming. Normally, deletions are going to be in very small quantities. Moving a few albums isn't going to be noticeable, but a few dozen or a few hundred could be. > Clearly therefore there's likely some error in the recanning logic? If > deleting 19,000 records out of say 180,000 records is inefficient, > wouldn't it be better to... No, it would have been better to just run a full rescan. -- JJZolx ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=88639 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
