Re: Close to a million records & query too slow

[sabelo simelane]

Could you also assist me with this query now based on the same schema.

select artist.artistId, artist.name, count(play.playId) as plays from charts.play play, charts.artist artist, charts.song song where (play.songId = song.songId) and (song.artistId = artist.artistId) and (date(play.dateAndTime) >= ?) and (date(play.dateAndTime) <= ?) and (artist.isLocal = ?) group by artist.artistId order by plays desc;

This query seeks to retrieve all artists with the most number of plays in the date interval.

Thank you in advance for your ingenuity.

--
Sabelo