Can someone spot a way to improve the performance of this query? I see
that every time it runs, it's "Copying to tmp table" and then
"Creating sort index" and taking way too long.
select count(distinct(stats.ip)) as popcount, stats.id, episodes.title
from stats, episodes where stats.id=episodes.id and
stats.type='listen' group by id order by popcount desc limit 12
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
