Re: oracle objects

2 cents:

Without putting a bunch of code up here, I did want to point out that objects can be extremely useful. Yes, they are completely unforgiving from a *developing by evolution* approach, but the neatness of passing around entire objects and modeling them with real-world behaviors makes them indispensible in my book.

I run a DB that models portfolio risk, and objects lend themselves nicely to securities. In the places I have chosen to use objects, I've noticed no performance penalties. To the contrary, I have seen great improvements in areas like returning years of pricing on hundreds of equities (nested tables). The penalty has been increased time-to-production.

"Christopher Anglin" <Dovestarr_at_erols.com> wrote in message news:xsQO7.75775$Ze5.43168750_at_news1.rdc1.md.home.com...
> Hi,
> This might seem like a simple question but can someone explain how to
use
> Oracle Objects and Nested tables well? They seem a LOT slower than
straight
> relational and the join on nested tables to get results seems no different
> than relation except it is harder to access and slower. I am not using
Java
> and most things are done by SQL or rather simple PLSQL.
>
> Does anyone have good samples of code?
>
> Chris
>
>
>
Received on Mon Dec 03 2001 - 23:38:51 CST