RE: Database programming standards

  • From: Jared.Still@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 3 Jun 2004 14:44:35 -0700

> Many developers dislike storing business logic in the database for a 
number
> of reasons
> - Application servers can be scaled out more easily than can database
> servers.  Throwing an extra machine or two in the application server 
cluster
> is a relatively simple operation.  Throwing an extra machine into a 
database
> server cluster, particularly if you're not using RAC everywhere, is much
> more complicated.  Realistically, very few applications need this sort 
of
> scale out, but there are a few.

Of course, if the business logic is in the database, there will be far 
less
need for more app servers.

Conversely, adding app servers is going to enventually require scaling on
the database end as well, as the database will be acting more like a
data gofer, and more app servers will require more singleton data 
accesses.

Jared

Other related posts: