RE: Object relational features and performance

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 20 Dec 2002 08:39:29 -0800
Message-ID: <F001.0051FE8F.20021220083929@fatcity.com>

Stefan - I believe the general consensus had emerged that usually object features aren't worth the effort. Often there are few benefits, and if you don't do it correctly you may see bad performance. Two questions:

1. Are your developers/management enamored with the concept of object, or is this just your own curiosity?
2. Is there something about your application that leads you to believe that it might derive significant benefit from the object features? For general business applications it is hard to beat the flexibility of the good old traditional relational data modeling. The lack of discussion may provide part of the answer to your question.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, December 20, 2002 6:35 AM
To: Multiple recipients of list ORACLE-L

Hi everybody

I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct ;)) things in the archive.
Anyway: Due to my lack of experience with any real life scenarios with Oracle's object relational features, I never tried to recommend the usage of these and always kept to a "normal" relational approach. Does anybody have any experience with Types / Nested Tables and the like in a (preferrably big) production system of any kind ? What's recommendable, where are the pitfalls ?

Any input deeply appreciated,
TIA, Stefan  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stefan Jahnke
  INET: Stefan.Jahnke_at_bov.de

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: ListGuru_at_fatcity.com (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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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). Received on Fri Dec 20 2002 - 10:39:29 CST