What is the best way to get TOP players in mysql?

Question

MySQL

Good evening,
there is a task to display to users in the game the top players sorted by some key. Will the selection slow down if I do the usual select order by param desc for each user?
What approaches exist for the optimal output of the top?
While I see the obvious - we display it once for the user's session and then take it from the session.

Answer 1

y. Will the selection slow down if I do the usual select order by param desc for each user

will not. All fields by which you will sort and select should be indexed
Never do this. Sessions are not for that. You don't need to cache queries either. Let the database handle it.

Answer 2

memcached, sphinx