There is the SQL for that "improved" query:
Code:
--------------------
SELECT DISTINCT me.id, me.name, me.namesort, me.namesearch,
me.musicbrainz_id, me.musicmagic_mixable
FROM genre_track AS genreTracks INNER JOIN (tracks AS track INNER JOIN
(contributor_track AS contributorTracks INNER JOIN contributors AS me ON
contributorTracks.contributor = me.id) ON track.id = contributorTracks.track)
ON genreTracks.track = track.id
WHERE (((genreTracks.genre)=7) AND ((contributorTracks.role)=1 Or
(contributorTracks.role)=5))
ORDER BY me.namesort;
--------------------
That query, though I assembled it in ms access linked to the SC data
via odbc, executes perfectly using the MySQL query browser, and, again,
returns the 37 rows in a fraction of a second.
So, what I'm inferring here is that for some reason, the SBC is using a
different call to fetch artists for a genre than is the web interface.
With library statistics turned off, the web interface is plenty fast
for me. But the SBC seems to choke, croak and die on me when trying to
fetch the same data.
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=46850
_______________________________________________
jive mailing list
[email protected]
http://lists.slimdevices.com/cgi-bin/mailman/listinfo/jive
