At 14:50 22.11.00 , you wrote:
> > so, what many people say, that this has limitations in scalability
> > (probably won't be able to build amazon.com that way) is true but it's
> > oversimplifying to say there are no areas where this approach is good in
> > real world practice or that those areas are not ejb-typical. ejb != 1000
> > transactions per second type of applications.
>
>So, i guess a conclution would be to use sql wrapped in session beans when
>the transaction load is greater than 1000 (which is quite a huge load :-)

I wouldn't say it's that simple but the dumb one-row-one-entity approach 
oviously does have its limitations. personally I prefer application level 
caches (especially for read mostly parts of applications) for getting 
things faster (if the underlying infrastructure==cmp engine is already 
tweaked to its limits).

>Generally i don't like the thought of building on a technology that i would
>need to hack around and directly access the database again, by-passing the
>ejblevel. Hopefully that is NOT the case in 99% of the cases.

generally, I'd agree with you but then again designing real world 
applications IMHO is all about trade-offs. I'm not a big fan of sacrificing 
design and abstraction or db-independence for the sake of performance but 
sometimes IMHO there's no choice. maybe things get better with ejb2.0 with 
complex queries but iterating through collections in many cases is a poor 
replacement for a handcrafted complex sql query. besides I have yet to be 
involved in a project where the application is taken and migrated from an 
RDBMS  to an OODBMS. so far having sql in a session bean (when necessary) 
hasn't hurt that much, provided that it's properly shielded from the client.

regards,

robert


>/Jon
>
>
>
>--
>--------------------------------------------------------------
>To subscribe:        [EMAIL PROTECTED]
>To unsubscribe:      [EMAIL PROTECTED]
>Problems?:           [EMAIL PROTECTED]

(-) Robert Kr�ger
(-) SIGNAL 7 Gesellschaft f�r Informationstechnologie mbH
(-) Br�der-Knau�-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665401, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de



--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]

Reply via email to