0
Hello
The site I am currently working on was developed using Laravel, using MYSQL as the database. The base currently has 500,000 registered players. Each player has a score. Currently the system shows the 50 best, so I make a consultation in the bank catching only the first 50 best results. When a profile is accessed, if it is among 50 is displayed its rating, otherwise does not appear the rating.
But now the system has to be modified and is being 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 in a table with 500,000 results thousands of times a day.
In this case, I ask you. What is the best way to display this data without overloading the system? It is feasible to display a ranking on a large basis?
500 grand is a lot, isn’t it? Best keep the 50 and in case you’re not in the 50, make a query by the player’s name to see what his rating is
– Sam
If I’m going to make a 100-page pagination, I’d make 5,000 pages... I think it’s unfeasible
– Sam
What is the schematic of the tables of this system? I have worked with great amount of data and one solution I found was to use the
indexesMYSQL. So queries, even being large, are better filtered and will not overload both the database.– Amilton Baracy