[SlimDevices: Beta] Re: 6.5b2 retrograde progress?

[Robin Bowes]

gharris999 wrote:
> Code:
> --------------------
>     
>   SELECT COUNT( DISTINCT( track_2.id ) ) FROM genres me 
>   LEFT JOIN genre_track genreTracks ON ( genreTracks.genre = me.id )  
>   JOIN tracks track ON ( track.id = genreTracks.track ) 
>   LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = track.id )  
>   JOIN contributors contributor ON ( contributor.id = contributorTracks.contributor ) 
>   LEFT JOIN contributor_track contributorTracks_2 ON ( contributorTracks_2.contributor = contributor.id )  
>   JOIN tracks track_2 ON ( track_2.id = contributorTracks_2.track ) 
>   WHERE ( ( ( ( ( contributorTracks.role IN ( '1', '5' ) ) 
>   AND ( me.id = '7' ) ) ) ) );
> --------------------

I ran this on the slimserver DB from phpMyAdmin and got the following
result:

Showing rows 0 - 0 (1 total, Query took 1.5777 sec)
COUNT( DISTINCT ( track_2 . id ) ): 2010

I then looked in genres and chose one that had a lot of tracks - Rock in
my case:

Showing rows 0 - 0 (1 total, Query took 37.2680 sec)
COUNT( DISTINCT ( track_2 . id ) ): 7518

Hmmm. Something definitely not right there.

R.