Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Complex Object Retrieval doesn't work
I'm using Oracle object extensions. I use nested tables and table of
refs.
I've tried to read my data with OCI and OCCI but tracing accesses to
db I find a lot of roundtrips: one for each ref to be read. Much more
with OCCI which is several times slower.
I've tried to set Complex Object Retrieval parameters with but I got
no results: roundtrips are always the same and its time is 55-60% of
my app total time.
I used following configurations:
server: tru64 5.1b + ora 9.2.0.4 - client: tru64 5.1b + ora 10.1.0.2 server: tru64 5.1b + ora 9.2.0.4 - client: tru64 5.1b + ora 9.2.0.4 server: tru64 5.1b + ora 9.2.0.4 - client: winxp + ora 10.1.0.2 server: tru64 5.1b + ora 9.2.0.4 - client: winxp + ora 10.1.0.3 server: winxp + ora 10.1.0.3 - client: tru64 5.1b + ora 10.1.0.3
Have someone ever had successful results using COR ?
TIA Received on Sat Nov 13 2004 - 18:56:24 CST
![]() |
![]() |