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/ -- PGP fingerprint 3E85 0C7A FE11 42E9 A599 094D AE16 90F0 81AE 16FF, ID 81AE16FF Go not to the IRC for counsel, for they will say both yes and no. -- (with apologies to JRR Tolkien)