"van Geel, Leo" wrote:
>
> > -----Original Message-----
> > From: Rafael Alvarez [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 10, 2000 9:11 AM
> > To: Orion-Interest
> > Subject: Re[2]: EJB vs Servlets
> >
> >
> > I'm currently developing a big project using EJBs,a backend for a
> > one-hour delivery company. In fact, I'm using CMP EJB for the data and
> > a fakade object for processing.There were few factors that
> > influenced the
> > choice:
> > .- You don't have to code in SQL. That says a lot on easy manteinance.
> > .- Don't need to understand, as a programmer, the how of
> > inner working of
> > your RDMBS.
>
> This is one of the big dangers I see happening around me. Don't fall in this
> trap.
> You need to understand what is happening behind the scenes. Poor performance
> is the result.
> A programmer needs to understand how the the code is accessing the database.
> That is a different story than understanding the DBMS internals! It is one
> of the bad things about CMP EJB's. I do not believe that generated SQL code
> can be optimal for all the different relational database backends.
> Impossible!
>
> DBA's raise your voice!
>
> Leo van Geel
> Massey University
> New Zealand
I agree that you need to understand what is happening behind the scenes,
but that doesn't mean that you need to re-invent the wheel! CMP EJB's
allow developers to concentrate on the business logic rather than having
to worry about database access code, this is a good thing. Besides, I
have run BMP vs CMP tests on several App server + DB combinations, CMP
wins hands down every time.
Damian
