fphredd;515887 Wrote: 
> Hi Frank,
> 
> Giving another go with the new version, same track count issues...
> 
> Music stored on ReadyNAS.
> 
> ReadyNAS built-in SBS 7.42:
> Total Tracks: 43,202
> 
> Windows XP Desktop Running SBS 7.42:
> Total Tracks: 43,202
> 
> Media Monkey:
> 43,202 Files
> 
> ACC on Windows XP desktop (not really sure how to set it up on
> ReadyNAS):
> Total tracks: 41707
> 
> Hmmmmmm...

I thought you'd do some investigation on a smaller subset to see if
there are differences and where they actually are?

ACC performs a query with the following joins:

join contributors AS album_artist on albums.contributor=album_artist.id
left join tracks on tracks.album=albums.id
left join genre_track on genre_track.track=tracks.id
left join genres on genre_track.genre=genres.id
join contributor_track ON tracks.id = contributor_track.track  and
contributor_track.role in (1,6)
join contributors AS track_artist on contributor_track.contributor =
track_artist.id

So this also means that if certain tags are not used, they will not be
included in the query results. So I suspect that you have a number of
tracks (43,202 minus 41707 to be exactly) which are not tagged fully.

Frank


-- 
SilverRS8

Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for
SqueezeCenter '_' (http://www.badkamerpech.nl) SlimServer.
2xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS
------------------------------------------------------------------------
SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818
View this thread: http://forums.slimdevices.com/showthread.php?t=74452

_______________________________________________
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss

Reply via email to