I have a extremely large forum, the load time for forums and posts are extremely long, even with my rather robust server. Currently our database is around 11GB. Due to the large amount of posts, when attempting to load any forum or post, the time has drastically descreased. I am currently trying to prune around 4million posts. How ever, even with my rather robust server, the pruning time is dire slow. It has taken me about 6 days to delete 100,000 posts. At this rate I won't be be done for years.
Is there any way to prune at a faster rate? Possibly setting limits so only a certain amount of posts are pruned? Currently when I run it, it attempts to prune 2.8 million posts. Perhaps that is why? I dunno, either way. I need to find a fast way to prune this quickly?
09-20-2008, 07:54 PM
Fastest Way to Prune?
Threaded Mode