sjj1805 wrote:Many of the Tutorials and similar links would be lost by pruning.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.
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.
Forum Pruning
Moderator: sjj1805
- sjj1805
- Site Admin
- Posts: 1194
- Joined: Fri Oct 27, 2006 12:45 am
- 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: