[MySQL]Group By a Count

[zivan]

Nasel jsem informaci, ze COUNT(DISTINCT user) je dost pomale (http://dev.mysql.com/doc/refman/5.0/...mization.html), tak muzes otestovat toto:

SELECT page, COUNT(user) FROM (SELECT DISTINCT user, page FROM temp) as temp2 GROUP BY page;