Matrix Games Forums

Hi guys, I'm not to technically sound with computers, but I've noticed that the stats loading at the end of a game (played or autosimmed) takes a lot longer than before. A game takes 5-10 minutes to unpack the game stats (the screen before the replays at the end). I tried a new install and still the same problem. Do you guys know what the problem may be?
Thanks,
Long Time Fan

What season are you in? and how big is you're league?

I have noticed that after a few years the player stats table in the DB becomes really huge. After it reaches 7000 to 8000 entries the processing of player stats after games takes forever.

Thanks mikvik,
Harddisk crahed about 3 hrs after the post (so that may explain it).  Just got the computer back.
Later,
Long Time Fan

Is there a good way to deal with this?  Can you delete retired players in order to keep the size of the player table down?  I'm in this for the long haul and don't want to have to give up when the games take an hour just to sim.

Unfortunately, under the current configuration I don't think so because of the way the game appears to use the player stats table in the league database. From what I surmise even after a player retires their stats are left in the player stats table and that causes a problem in long range games or games that have many teams. One thing you could do to speed up the process would be to delete the stats of previous years using Access. But that would mean you would lose the stats of retired players so it would kind of defeat part of the purpose for long-term leagues.

I would suggest that maybe David should have a separate table for retired player stats so that the player stats table does not grow beyond the first year's length.

*edit*
Actually, I thought about it some more and there is a way that might be a possibility. What you could do is every time you start a season you could move the previous year's stats from the stats_players table into a blank league database. So that the current years stats compile in a blank stats_players table. When you want to see the career stats you just add the stats from the blank data base back into the original league file.

I've been thinking of ways to deal with this too and the only solution I've come up with is similar to what you have proposed.