End Game Problem

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

End Game Problem

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Current Games From Matrix.] >> [Sports] >> Maximum-Football 2.0 >> End Game Problem

Page: [1]

Message

<< Older Topic Newer Topic >>

End Game Problem - 6/26/2008 6:28:34 AM

long_time_fan

Posts: 93
Joined: 8/18/2007
Status: offline

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

Post #: 1

RE: End Game Problem - 6/26/2008 6:49:16 AM

micvik

Posts: 139
Joined: 10/23/2007
Status: offline

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.

< Message edited by micvik -- 6/26/2008 7:37:11 AM >

(in reply to long_time_fan)

Post #: 2

RE: End Game Problem - 7/9/2008 3:27:08 PM

long_time_fan

Posts: 93
Joined: 8/18/2007
Status: offline

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

(in reply to micvik)

Post #: 3

RE: End Game Problem - 7/25/2008 12:50:16 AM

chad56s

Posts: 47
Joined: 2/9/2008
Status: offline

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.

_____________________________

(in reply to long_time_fan)

Post #: 4

RE: End Game Problem - 7/25/2008 12:36:48 PM

micvik

Posts: 139
Joined: 10/23/2007
Status: offline

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.

< Message edited by micvik -- 7/25/2008 2:56:15 PM >

(in reply to long_time_fan)

Post #: 5

RE: End Game Problem - 7/26/2008 4:34:54 PM

chad56s

Posts: 47
Joined: 2/9/2008
Status: offline

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.

_____________________________

(in reply to micvik)

Post #: 6