Forum Pruning

Items not falling into any other specific category

Moderator: sjj1805

Post Reply
User avatar
sjj1805
Posts: 1120
Joined: Fri Oct 27, 2006 12:45 am
operating_system: Windows 10 Pro
motherboard: Hewlett Packard 2AF7
system_drive: C
32bit or 64bit: 64 Bit
processor: 2-90 gigahertz Intel Core i5 4460S
ram: 8 GB
video card: NVIDIA GeForce GT 705
sound card: P40D100-4 NVIDIA High Definition Audio
Hard_Drive_Capacity: 8 TB
Location: Birmingham UK
Contact:

Forum Pruning

Post by sjj1805 » Tue Jun 22, 2010 10:28 am

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.

Post Reply