Seriously, we don't need 100 threads about it. We are aware that it's a problem, and we don't like it any more than you do, since it slows down doing support.
The caching updates I have done have helped a little bit, but they don't really address the main problem. If you haven't noticed, the big lag spikes tend to happen most at the around half-hour mark and at around the top of the hour: when sims finish. They do a big dump of all their stats and pbp data, which makes the disk on the database machine go crazy with all the updates, slowing down everything else at the same time. It's become more pronounced as we've added more teams and run more sims every season.
I do have a plan in place to address this, but it will have to wait until offseason unfortunately. It involves splitting all the sim data onto its own database to alleviate CPU load on the main database server. The code is written, but it's too risky to try and fit it in while all the sims are still running season 3 code, since the updates involve updating the sim code (with all the season 4 changes inline as well). I would rather suffer through some slowness than spend several hours sorting out broken playoff sims because I missed something somewhere.
The caching updates I have done have helped a little bit, but they don't really address the main problem. If you haven't noticed, the big lag spikes tend to happen most at the around half-hour mark and at around the top of the hour: when sims finish. They do a big dump of all their stats and pbp data, which makes the disk on the database machine go crazy with all the updates, slowing down everything else at the same time. It's become more pronounced as we've added more teams and run more sims every season.
I do have a plan in place to address this, but it will have to wait until offseason unfortunately. It involves splitting all the sim data onto its own database to alleviate CPU load on the main database server. The code is written, but it's too risky to try and fit it in while all the sims are still running season 3 code, since the updates involve updating the sim code (with all the season 4 changes inline as well). I would rather suffer through some slowness than spend several hours sorting out broken playoff sims because I missed something somewhere.






























