UBB.Developers Forums UBB.threads 7 Development How Do I? General Consensus on 6.5?

I've been waiting a little while to upgrade my forum from 6.4 to 6.5 because of the typical bugs, problems, etc. So would you guys say that 6.5 is good enough for production use now?

My biggest reason for wanting to upgrade is for the advertised speed boost. Ever since 6.4, my forums get pretty slow under heavier traffic (50-75 users online) and MYSQL tends to bog down (lots of "Writing to tmp table" messages in process list).

Has everyone had pretty good success with 6.5?

Thanks!

Jeff
CustomTacos.com

With nearly 400,000 posts, I assume you're on a dedicated server?

6.5 has an annoying bug that can bite forums with large numbers of forums and users that read many, many topics in one session - it involves new post notification not working correctly. The upcoming 6.5.1 release fixes the problem, so you'll probably want to wait for it.

Just to add my experience - yeah if 6.5.1 is coming soon, wait on it. But many of my clients have noticed speed improvements with 6.5.

Yeh, it's a dedicated P4 2.8 with 512MB. It usually runs very well, but gets slaughtered pretty bad at night under heavy traffic. I'm hoping 6.5 will bring the speed back that was lost from 6.3.x.

Double the memory and re-tweak MySQL - that will also provide a speedup. You'll need to do that in any case if you don't want to prune.

(Less messages -> better performance.)

50-75 users is heavy traffic? I'm about to get a P4 2.4 with about 350 users at peak times, will the server fold under the pressure? I will have 1GB RAM though.

Charles, what do you mean by re-tweaking MySQL? What exactly can be done to improve performance/speed?

And Part 2

Ok, this is definitely a dumb question, but what's the best way to prune forum categories? I've been manually going in and removing old useless threads, but is there a more automated way? (I'm probably missing something obvious)

Thanks for the links, fellas!!!

Jeffro, I think there's an option to have posts automatically deleted after 'x' number of days. This is the only way to automate the process as far as I know.

Speaking of fine-tuning the system, would it be right to assume that if something takes AGES (say 10 secs.) to load, but the footnote shows up as "Generated in 0.025 seconds in which 0.009 seconds were spent on a total of 8 queries. Zlib compression disabled"...

...then it's not MySQL's fault? Would it still be the server's fauly (maybe other stuff lined up?), or could it simply be the connection?

[]but what's the best way to prune forum categories?[/]There's a cron script - doexpire. Check it out.

[]if something takes AGES (say 10 secs.) to load, but the footnote shows up as "Generated in 0.025[/]That does sound like a connection issue, yeah.