Hello
The site I am currently working on was developed using Laravel, having MYSQL as the database. The base currently has 500 thousand players registered. Each player has a score. Currently the system shows the top 50, so I make an appointment at the bank picking only the top 50 best results. When a profile is accessed, if it is in the 50's your rating is displayed, otherwise the rating does not appear.
But now the system has to be modified and is required to show the position of each of the 500,000 players in their respective profiles. However, I find it extremely stressful for the system to have to search on a table with 500,000 results thousands of times a day.
In that case, I ask you. What is the best way to display this data without overloading the system? Is it feasible to display a rating on a large basis?