I was gone for a few hours there while it seems my Spam Karma 2 plugin ran amok on me, grinding the webserver to a snail’s pace. It seems that the plugin doesn’t index the database very efficiently. I’ve only been using the plugin for about a month and a half (after I gave it two thumbs up) and of about an 800Mb database (which is quite a lot of text), half of it is Spam Karma data. I think it was breaking my Post Preview as well, since that’s suddenly returned after a bit of an absence.
Anyway, I’m back to Akismet for spam prevention, I’ve removed some of my plugin cruft as well as nixed a couple of plugins I had been using for stats and such. In the process though, I found an update to the Post Teaser plugin I had been using a while back, but had to disable following a WordPress update some time ago. Hopefully nobody finds it too annoying ;^)
Actually, the problem you have found is a very dire one… and entirely WordPress’ fault.
Indeed, WP’s original database schema (up to the very latest version) doesn’t include the most basic indexing (and I’ll stop here, before I start frothing at the mouth at how stupid that is). This has little, if anything, to do with SK2, which shouldn’t be expected to modify WP’s tables to work.
I was therefore forced to add a core DB update to the latest version of SK2 that I am working on releasing any time soon (beta containing this fix should be out by the weekend)… This should fix your (and many others’) problem…
Dave, my faith is restored — thanks… I’ll check back early next week for the update. SK2 works fabulously imo, and clearly outperforms Akismet in my experience… as evidenced by the fact that Akismet sent your comment to moderation. Keep up the excellent work!
Also for the record, I accused SK2 of breaking the preview in the post writing page — in fact this appears to be caused by the CG-Referrer plugin and not by SK2. I still can’t find a decent stats program that I like… stats should actually be built-in to WordPress.