Re: choices regarding where to place code - in the database or middletier

Joe Weinstein <joeNOSPAM_at_bea.com> wrote in message news:<400EB04E.1010101_at_bea.com>...
> Depending on an external layer for what the DBMS is best at, *is* begging
> for problems. However, I believe there's a lot that the DBMS can't do well,
> and depending on the DBMS to do that stuff is also begging for problems, in
> performance to start.
> To repeat the inarguable example, the DBMS can't even do the basic job it was
> designed to do by itself, in a test designed specifically to exercize a DBMS,
> as fast by itself, as it can when it uses an intelligent middle tier.
> We're focussing on our differences, but I am also a DBMS guy, and we would
> probably agree for the most part on specific functionality that should be in
> the DBMS.
> Joe Weinstein at BEA

Apparently you have been brainwashed and consider middle-tier to be THE Gospel, and now you are trying to brainwash others. Your assertion 'depending on the DBMS is begging for problems' demonstrates that clearly: you simply don't know what you are talking about. I have seen NO (I repeat NO) middle-tier applications that couldn't be qualified as a complete DRAMA. Anyone with only a little bit of experience in the field is aware of that.
There is NOTHING in a middle-tier that couldn't be done by a DBMS, in most cases having it done by a middle-tier 'application' is at it's best asking for something completely unscalable (which BTW everyone with a little bit of experience knows).
I would contest you are a 'DBMS guy', if you really are a 'DBMS guy' you wouldn't have made your completely erroneous claim 'depending on a DBMS is begging for problems'
Depending on a middle-tier however IS, as everyone knows, BEGGING for problems, especially when being used by inexperienced developers (and middle-tier 'applications' are ONLY being developed by inexperienced developers)

Sybrand Bakker
Senior Oracle DBA Received on Thu Jan 22 2004 - 06:23:00 CST