Hot Topics
For the last several days, the server has been running fairly well, except when the database gets corrupted. It's easy to fix, but takes a while. On Sunday, apparently the DB was corrupted and I wasn't available to fix it for several hours. And then again this morning, one of the tables was corrupt, so I had to rebuild.
I did notice that the times when the server gets busybusybusy is when the Hot Topics on the front page are updated. Those used to be updated once every four hours. So now, I've adjusted it so it's updated once every day, at 2 a.m. The only alternative is to take them off totally.
Fun historic fact: that "Hot Topics" area has been on BZP since the early days, and was initially set to update dynamically, in real time. That became a major, massive drain on our (then) shared server, so we got booted from there. Through time, we discovered how to optimize it and make it better, but it's still a resource hog. I want to keep it, but it's hurting the server, so I've got it running when fewer people are online. Hopefully that'll help.
11 Comments
Recommended Comments