I'm running our 1.3million post board on a dual processor box with two gigs of memory, but still occasionally see some ugly performance. Looking at MySQL stats, we see lots and lots of queries that get executed without use of keys - thus doing full table scans.

I'm not sure if that's our main bottleneck, or if it's elsewhere, but I do have this generic question:

Is it expected that v7 will run much more quickly and efficiently than v6? Will I see much quicker responsiveness day to day on the boards once upgraded, or will my "who's online" average of 200 to 250 users pummell this thing?

Thanks,
Arch

Last edited by Architecht; 09/14/2006 6:18 PM.
[Linked Image from boards.collectors-society.com]