Philip Meyer;698514 Wrote: > > >I've always felt with the scanner/database is that no album artist is > >assigned to albums that have none in the metadata. > > Doesn't the scanner do this, always storing an album artist in the > album record (albums.contributor), but doesn't always store as a > contributor role in the link table? > So every album has a single album artist id, whereas some albums could > have multiple album artists if it were in the link table.
No, it does not. It stores a contributor that is used only for album sorting (by artist) purposes. It does not store an album artist role in the contributor_album table for the album. If there is no ALBUMARTIST tag, then every time it puts together an 'album_name by artist' string it has to retrieve the artists for every track on the album and then parse them to construct the string. This is why, if you have no ALBUMARTIST tags for non-compilations, generating a single page full of albums requires hundreds of queries. As an example, if you had a page of 100 albums with an average of 12 tracks per album, it will take a minimum of 1200 queries just to generate that one web page. It's little wonder that it takes a couple of seconds to spit out a page on even the fastest servers. Doing it the other way would take _one_ query. -- JJZolx ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=94357 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
