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
On Wed, Jul 9, 2008 at 12:47 PM, Brian Dunning [EMAIL PROTECTED] wrote:
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.
You're sorting by a computed field. That's