If you are talking about rewriting it I assume you have the open
source version. CF Forums main bottleneck is that it uses subqueries
to generate the message counts. Get a lot of messages, or a lot of
forums and it starts to blow a gasket. It's also been a while and
there may be a new version out...so my experience may be outdated
here.
The key optimizations that needs to be done it start precalculating
those topic totals, etc, remove all the looped over queries, then
start in caching.
In the end I was able to get a forum with 50! forums and over 75,000
messages displaying in sub 100ms times with a single user, before
any db optimizations. Under load it did well...can't remember times
though.
--
mailto:[EMAIL PROTECTED]
Friday, October 17, 2003, 12:21:35 AM, you wrote:
RS> Hi all,
RS> Has anyone here implemented a high volume site using CF FORUM 2000?
RS> We have just inherited one, and am wondering how solid the code is.
RS> Its a very busy forum, doing about 3 gigs of traffic per day, and its
RS> started to show signs of breaking down, e.g. deadlock errors,
RS> timeouts, "No more data available to read" errors.
RS> Should I be looking for different forum software? Or re-write the code
RS> myself?
RS> Has anyone done an optimisation job on the CFFORUM code and can give a
RS> few pointers on where the bottlenecks are?
RS> thanks, bye!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
