13 reputation
2
bio website
location
age
visits member for 2 years
seen Dec 10 '12 at 18:34

Dec
10
awarded  Student
Dec
10
awarded  Scholar
Dec
10
accepted MySQL “Limit” clause grabbing more results than requested
Dec
10
comment MySQL “Limit” clause grabbing more results than requested
Ah .. I had indexes on [username, points] (reverse order) - switching them around solved the issue. Thank you.
Dec
10
comment MySQL “Limit” clause grabbing more results than requested
I'm trying to get the retrieve the usernames along with their points. Without a subquery, my query was scanning all 5000 rows just to get the 100 results that were needed. As you can see above, it only needed to scan 200 rows to get the results I'm after.
Dec
10
comment MySQL “Limit” clause grabbing more results than requested
Moving one (or both lines) causes the query to return all rows.
Dec
10
asked MySQL “Limit” clause grabbing more results than requested