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...
