I'm working with a ranking of more than 500 teams, using php. The ranking has daily change, with each game of any team that appears in that base. The question is, how to show the classification of a certain club on a certain date?
For example, if you are filtering by Team A's position on 8/8/2008, I am currently catching ALL teams, playing in a table, and yes, taking your ranking on that date. But I'm finding it very complex, because at each request, a table is set up with all the teams, so yes you can filter the classification. If I increase my database to 2,000 teams for example, I will have to put together a classification with 2,000 teams for example, and then display the result, which would cause a huge overhead. To show all other results the procedure is very simple, but I'm having trouble showing the sort on the date.
How can I implement this in a more simplified way?