On Fri, 1 Mar 2002, Perrin Harkins wrote: > However, there is a big advantage in being able to put most of the > processing work onto middle-tier machines that are easy to load balance. > Scaling a big Oracle server is expensive, and pretty hard after a > certain point. Scaling application servers can be as simple as ordering > another 10 Intel boxes. This is one of my main objections to running > stored procs.
I used to work at a place (Digital River) that had (and I think still has) a giant web app that served up thousands of web stores. The entire app was written in PL/SQL and was served with Oracle 7.x on a big old Sun 6k machine. They had something like 16 processors and several gigs of RAM. This just did not scale. While I was there they hit a point where the traffic was big enough that the machines were struggling. They had a little room to upgrade (a 10K machine I guess) but not a heck of a lot. It was a disaster. -dave /*================== www.urth.org we await the New Sun ==================*/
