Been talking with the hosting company after letting the new version bed in on the new server and there are a few minor config tweaks that are going to be made. Most of them shouldn't affect the user experience but the idea is to reduce the load on the server - basically the database side of things is getting constantly hammered so we are looking at reducing the load.
The main one that might make a difference is that I've extended the time that search results are cached from 1 to 2 minutes. This may make the Most Recent Activity and Todays Posts pages slightly less up to date. You shouldn't notice it (after all, I've only made it 2 minutes) but we'll see.
We're also looking at swapping the search engine out. At the moment the database indexes its own search results, in addition to all the usual retrieval of posts, topics and all that. By offloading the search this should take some of the heavy load away from the database. Not sure when this will happen.
To give you some idea of how much traffic we generate, on average for the past month we have ~150 active (logged-in) users making ~450 posts a day. And there are a lot of non-registered lurkers as well building up ~2Gb of traffic every 24 hours.
Finally there might be a little downtime for me to apply a security patch.
The main one that might make a difference is that I've extended the time that search results are cached from 1 to 2 minutes. This may make the Most Recent Activity and Todays Posts pages slightly less up to date. You shouldn't notice it (after all, I've only made it 2 minutes) but we'll see.
We're also looking at swapping the search engine out. At the moment the database indexes its own search results, in addition to all the usual retrieval of posts, topics and all that. By offloading the search this should take some of the heavy load away from the database. Not sure when this will happen.
To give you some idea of how much traffic we generate, on average for the past month we have ~150 active (logged-in) users making ~450 posts a day. And there are a lot of non-registered lurkers as well building up ~2Gb of traffic every 24 hours.
Finally there might be a little downtime for me to apply a security patch.
Comment