Forum OpenACS Q&A: Re: Largest OpenACS community?

Posted by C. R. Oldham on
We have over 30000 registered users on our site.  Of those, approximately 10000 I would define as "active".  The webserver is a dual 800Mhz Xeon with 1 GB of RAM.  The backend is Oracle on a dual 2.6GHz Xeon with 4 GB of RAM.

We wish it was faster. :-)  Our testing indicates that most of the bottleneck is in the database.  We've done a lot of query tweaking for our internal packages, and that has helped.  I'm afraid we are now at the point where the only way to really make the site smoke is to drop serious cash on a bigger Oracle box.  We've also been thinking about moving to a 9i RAC configuration with two servers, but I'm unsure if that will really help us in the performance department, and that means *really* serious cash because you need some sort of SAN configuration, none of the infrastructure for which do we have in place...

Posted by Denis Roy on
I think upgrading your memory would help. We had a similar problem some months ago and our first step was to upgrade RAM from 1 to 2 GB and make heavier use of util_memoize. It helped a bit, the webserver would support about 60-70 concurrent users instead of only 40-50 before getting awfully slow and unstable.