0
I am working with a ranking with more than 500 teams, using php. The ranking changes daily, to every game of any team that appears on that basis. The question is, how to display the classification of a certain club on a certain date?
For example, if you are going to filter by the position of Team A on 08/08/2008, I am currently picking up ALL teams, playing on a table, and then getting their ranking on that date. Only I’m finding it very complex, because with each request, a table is assembled with all the teams to then yes filter the classification. If I increase my database to 2,000 teams for example, I will have to assemble a ranking with 2,000 teams for example, to then display the result, which would cause an immense overload. To show all the other results the procedure is very simple, but I’m having difficulty showing the classification on the date.
How can I implement this in a simpler way?
What is the database?
– Thiago Santos
A MER from your bank would be useful
– Lucas