Rectangle 27 0

php Best practices storing, modifying and retrieving user reputation data?


select count(*) from user_points where points > x

Does just doing the direct approach (using the index you already have) work? I'm thinking of something like:

where x is the number of points for the user you are looking at.

Note