Heath
Sun 25th May '08, 3:46am
My VB has started to go down frequently, I contacted my server to see what the problem was, and they said it was due to the massive database size of the vb board. So after hearing that, I decided to start pruning some posts. While doing this I noticed there was a extremely large amount of duplicate posts of the exact same thing. We were using the RSS importer for some time and over time it accumulated way to many posts for my taste. I simply forgot it was still running because I wasn't checking the forums frequently up until they began getting more traffic, and it started causing server issues effecting my main site outside of the vb.
So my question is, would it be ok to alphabetically sort the threads via phpmyadmin, and remove them from there, leaving one with that title? Or would this effect the rest of the site and cause errors?
If there are any other ways to do this that will not be a heavy server strain please let me know. Right now none of the forums will load the threads in order to delete them that way, and the duplicate delete in admin hasn't worked due to the large amount of posts. I left it there doing some thing for hrs then it finally just loaded a white page.
So my question is, would it be ok to alphabetically sort the threads via phpmyadmin, and remove them from there, leaving one with that title? Or would this effect the rest of the site and cause errors?
If there are any other ways to do this that will not be a heavy server strain please let me know. Right now none of the forums will load the threads in order to delete them that way, and the duplicate delete in admin hasn't worked due to the large amount of posts. I left it there doing some thing for hrs then it finally just loaded a white page.