Quote:
Originally Posted by Big Sexy
sam.. why dont you download the database and save it in your harddisk and then proceed to remove all those old data.. there are tons of them.. some dating afew years back.. those thread are either outdated or there is no new post anymore..
this way you could reduce the database size by at least half i reckon..
|
I download the database and save it on my hard drive. I then do the necessary housekeeping. However, by the time I upload it say 24 hours later, 4000 new posts will have been added and these will all be wiped out when I upload a day old copy of the database.
Housekeeping has to be done in real time and when it's done, it takes up server resources and the site will slow down. I try my best to do it all during non peak hours but those hours are getting shorter and shorter.