Hi there -- hope someone can help!
I currently have over 50,000 (!!!) messages in my "Awaiting Moderation" section.
Obviously, it's impossible to load the page with that many comments. I've been trying to bring the number down by doing search-and-deletes on various spam words, but the truth is, I'll never get it down to a point where the load is reasonable that way.
The main issue is that though 95% of these messages will be useless spam, the other 5% will be comments going to archived entries. (Any entry of my blog not currently on the blog main page has its comments sent to the "Awaiting Moderation" bin.)
I really don't want to lose the good comments that are trapped in there. Is there anything anyone can suggest that will let me clean up this mess?
Oh, and FYI: Sadly, I had to step away from the site for a few weeks, and that's how the spam got out of control. By the time I was back, it was at 15,000 and it's just climbed and climbed ever since.
Thanks in advance for your help!