I have just updated the site. The included changes do not impact the site layout. This update contains the following changes:
Rewrote several of the database queries used during the daily leader board updates. This should solve the ongoing problem where the daily update takes a long time to complete and sometimes fails to complete due it taking too long. See here for more details. In my test environment the leader board updates went from completing after about 70 minutes to 15. I'm anxious to see the actual time improvements tomorrow morning.
Some code refactoring. Basically, this just means that some of the code was rearranged and reorganized for maintainability but should have the same functionality.
Early this morning, the leader boards and statistics were updated in less than 18 minutes. The last two mornings that took about 3.5 hours and the morning before that 4.5 hours. This is good!
The site has been working great for me so I appreciate all the work getting things running smoothly on your end and solving behind the scenes problems that users like me haven't got a clue about.
Corfman Clan wrote:Early this morning, the leader boards and statistics were updated in less than 18 minutes. The last two mornings that took about 3.5 hours and the morning before that 4.5 hours. This is good!
awesome.. WTG Russell... glad to hear its all running smoothly..
Corfman Clan wrote:Early this morning, the leader boards and statistics were updated in less than 18 minutes. The last two mornings that took about 3.5 hours and the morning before that 4.5 hours. This is good!
This morning it took less than 13 minutes. Yes, things are good!
