Schneelocke wrote:
Hi Brion Vibber,
I've temporarily disabled talk page notification for IP addresses that aren't logged in, as this dumps an extra database query for every single hit.
If it doesn't make a big difference, it'll get turned back on shortly.
It does seem to make a noticeable positive difference.
It's unfortunate that we have to, that's a very important feature. It would probably be wise to advertise this in Wikipedia:Announcements, otherwise the rate at which anonymous users are banned will suddenly jump.
May I suggest also reducing the number of update queries to sitestats? I was going to do it myself, but I'm not going to have time for the next week and a half. My idea was to use a shared memory location which is incremented each time a page is viewed, and then flush it to the database once every 100 views. If a type of shared memory can be found which survives an apache restart, it would be very accurate. Then we just lose 50 views once a month or so. I'm not sure how much performance would be gained, but I'm willing to bet it's worth the effort.
-- Tim Starling.