I want to inplement a relative leaderboard, which means treat current user as the middle point and find 5 users have higher ranking than me and 5 users have lower ranking to me.
I didn't find method that allow me to do that directly, nor the method can use to retireve user based on his/her ranking.
I don't want to implement this in a way that get top 20 first and then get sublist of the top 20. This is not scale and will be very slow for the user who has a low ranking. Any one has any idea about how to achieve relative leaderboard?
Thanks in advance.