Re: stored procs? why?

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
==================*/