>An additional change you can try if you use this in a new 7.1 release,
>is that you could replace "track_statistics" with "tracks_persistent"
>and join using tracks_persistent.track instead. This would be something
>like:
I just tried this and it returned a track that had a rating.
select tracks.url, t2.rating
from tracks
left join track_statistics t2 on
tracks.url=t2.url and t2.rating>0
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
tracks.audio=1
and t2.url is null
and dynamicplaylist_history.id is null
group by tracks.id
returns 20177 rows in 0.3774s
select tracks.url, t2.rating
from tracks
left join tracks_persistent t2 on
tracks.id=t2.track and t2.rating>0
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
tracks.audio=1
and t2.track is null
and dynamicplaylist_history.id is null
group by tracks.id
returns 20738 rows in 0.4051s
So the old track_statistics table join appears faster, and has more rated
tracks in it?
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins
