the table "serendipity_referrers" contains all referrers which ever visited a blog. During performance analysis of my blog i found out, that the runtime for this query:
Code: Select all
SELECT scheme, host, SUM(count) AS total
FROM serendipity_referrers
GROUP BY scheme, host
ORDER BY total DESC, host
LIMIT 10
Can this query somehow modified to not scan the whole table but instead use an index?