Philip Meyer;698559 Wrote: > The thing is, you can have more than one album artist per album.
Makes no difference. The database is set up for M:M relationships as it is (albums : contributor_album : contributor). If every album had an album artist or -artists- in the database, it would still take just one query to generate a list of albums with album artists. > It is possible to retrieve the correct info in less queries. eg. one > query to return a list of unique artists for all songs on an album, so > would require 1 query for the list of 100 albums, and 100 queries (1 > per album) to get a list of the artists on each album. I haven't looked at it in a while. At one time it appeared to be doing a query for every track on every album being listed. It may be smarter now. Still, there's no reason to be doing dozens of queries to generate a simple album list that also shows the album artists. -- 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
