I run sites for several friends using wordpress. On one (and only one) of them I have encountered a problem, I'll have to start at the beginning:
Front page of the site was slow (several minutes, random loading/not loading at all). I tried different things (disabled and removed all plugins, changed theme), but what seemed to help was limiting the number of posts on the front page to five (from ten).
Ok, so I think the problem is solved, but go into the "Manage" tab in admin mode and experience the same turtle-esque loading times. But there's more! :) After about a minute of loading, wordpress lists "five and a half" posts and stops. I say five and a half because it stops after the author-name on the fifth line/post.
Now, if this had happened on the same post every time, problem solved, but this happens no matter what. I've tried changing dates of posts, deleting, moving, same thing happens, but with other posts instead.
I've tried upping mysql-connections, php memory limits and more, no change.
I suspect corrupt tables in MySQL, but don't want to start messing with it until I'm sure.
The problem persisted through several versions of WP (I started with 2.05 and have now upgraded to 2.07)
I'm now completely stumped.
Any ideas at all?