Hi all,

We run a UBB forum with alot of volume:

Board Statistics
Version: 7.2.2
Total Members: 19,090
Total Forums: 72
Total Topics: 242,514
Total Posts: 5,434,546



As you can see we're still running 7.2.2 because we've been casually waiting forever for either v8 or v7.6 to come out.

One of our bigger headaches is the search function, which can lock up the boards for long periods of time. I've restricted the search range, search frequency, max results, etc.. However, in general, I think it's just poor code and data structure in the search function for dealing with this volume of posts.

We're in the midst of upgrading the hardware to 24gigs of ram as putting the whole database into RAM tends to speed things up.

However, does anyone have any thoughts on either:

1. Tweaks to the MySQL settings that are not part of the stock install to speed things up.

2. Whether there would be any significant performance improvements from the upgrade to 7.5. We've looked over some of the change logs and not had anything leap out at us, but I thought I'd check.


[Linked Image from boards.collectors-society.com]