Hiya.
The Nottingham OpenGuide[1] takes a considerable time to load the front page; if the machine it's on is using its CPU for anything else, at the time, it takes even longer. While it's loading, mysqld is taking up ~90% of the CPU time according to 'top', running (as far as I can tell) the query that generates the list of recent changes.
I had just put it down a One Of Those Things, but I noticed that the other, larger guides such as Oxford and London *don't* have this problem. So, I'm left thinking it's something I've not configured properly -- has anyone got any clues what that might be? People have mentioned MySQL indexes to me, but my understanding of what's going on with them is roughly nil.
Any suggestions are very welcome indeed...
Cheers, James.
[1] http://nottingham.openguides.org/