Re: Business-logic in 3-tier architecture
From: Pablo Sanchez <pablo_at_dev.null>
Date: 28 Oct 2002 07:11:05 -0600
Message-ID: <Xns92B53FE12ECE3pingottpingottbah_at_209.189.89.243>
Date: 28 Oct 2002 07:11:05 -0600
Message-ID: <Xns92B53FE12ECE3pingottpingottbah_at_209.189.89.243>
Michael Gast <mig-sm_at_web.de> wrote in news:3DBCEE51.9070403_at_web.de:
> and more: Portability; the languages for triggers and stored procs
> are DBMS specific.
The problem with the above is it ignores that at some point, a marriage must be made with the DBMS. Otherwise you end up with mediocre performance at best. Once the application is deployed, how can the DBA tune the SQL without affecting the application? When the logic is stored in the app layer, they cannot. This is one of the biggest flaws when storing the business logic in the middle tier only.
-- Pablo Sanchez, High-Performance Database Engineering http://www.hpdbe.comReceived on Mon Oct 28 2002 - 14:11:05 CET