Timeline for COUNT and GROUP BY performance
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 21, 2014 at 16:44 | vote | accept | yoshi | ||
| Jun 21, 2014 at 14:17 | answer | added | bartover | timeline score: 1 | |
| Jun 21, 2014 at 11:30 | comment | added | ypercubeᵀᴹ |
Do you want the top 10 countries, ordered by what? If it is by the most hits, then you need to use ORDER BY hits DESC LIMIT 10 and it won't be more efficient than the whole result.
|
|
| Jun 21, 2014 at 11:07 | history | asked | yoshi | CC BY-SA 3.0 |