I'll agree with Tom Kyte to a point. Caching database rows in the middle tier
is a bad idea since you have no idea if they've been changed at the database level by
another non three tier application, read that as SQL*Plus for instance. To get around
these "problems" WebLogic & it's similar variants have to query the database to see if
the row in cache is the same as the row in the database (column by column) & then
either process the update requested by the end user or send a incomprehensible error
message back. YUCK!! At a minimum this results is twice the amount of data being
sent between the middle tier server and the database, how inefficient!! Now if your
going to cache an entire "panel" as PeopleSoft calls them which are composed of
several rows of data from tables that change infrequently that's not such a bad idea,
although with some of the fun we've had recently with cached panels becoming corrupt I
may well change my mind.
BTW, Java Beans are fairly flexible and portable so he's not onto a bad idea.
But as with any programming language you can easily program yourself into some very
nasty corners. One should not use those "containers" for more than their meant to do
and caching data is not one of those purposes.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Tuesday, September 16, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L
Whenever I talk to DB people or read DB articles/books the consensus is to use a
database centric application. A person who just started recently says he has had alot
of success with 'caching' in a middle tier using BEA Weblogic and limiting calls to
the database.
Does anyone have any experiences with this? He says that the 'beans' also make it
highly portable. Just started reading Tom Kyte's new book and he says this is a big no
no. However, I like to keep myself open minded to people with differing ideas and not
have a total database bias.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
