Can't moderate 100,000 posts - crashes forum!

[Head-Nod.com]

Thanks Mark, that was very helpful.

I might try upgrading to a VPS first, to see if that gives me enough memory to cary out the purges online, as I have never setup an offline webserver or mySQL DB before, and it sounds like quite a bit of work. Will definately try to obtain a database backup from my hosts though, that was a good tip.

Is there any way to moderate un-moderated posts in blocks, rather than all at once in the Admin CP?

Or to delete all users who have no moderated posts, only unmoderated posts in the moderation queue?

Thanks!