Page 1 of 1

Forum Pruning

Posted: Tue Jun 22, 2010 10:28 am
by sjj1805
sjj1805 wrote:
Devil wrote:OK, I believe it is probable that the slowness may be at least partially due to the sheer size of the MySQL database. In all probability, this will be on a different server to the phpBB itself. As far as I can ascertain, this goes back to Nov 2004 at which time all the products were 2-5 versions earlier. They are therefore hardly relevant today. People doing searches rarely go back very far. I suggest that all posts older than, say, two years be archived and deleted from the current database. Similarly, all members who have not accessed the forum over the last year or so could be e-mailed to say that unless we hear to the contrary, they would be removed from the member list. These two actions should lighten up the database considerably.
Many of the Tutorials and similar links would be lost by pruning.
Last year we had over 38,000 registered members. I spent a couple of months whittling the list down and we are now at 18277 members - less than half of what it used to be.