Yeah, the thing is it shouldn't be doing it at all, there's no reason.
I'm wondering whether it's an indexing issue, as I have a load of custom indexes set up (the forum software by default doesn't have any, but without them pages take upwards of 10 seconds to load). The issue seems to resolve when I force the database to write all changes to disk.
I think I'll set aside some time next week to upgrade the forum itself and see if that does anything, maybe run some optimization on the db.
I'm wondering whether it's an indexing issue, as I have a load of custom indexes set up (the forum software by default doesn't have any, but without them pages take upwards of 10 seconds to load). The issue seems to resolve when I force the database to write all changes to disk.
I think I'll set aside some time next week to upgrade the forum itself and see if that does anything, maybe run some optimization on the db.