"news.tiscali.it" <c.vanti_at_tin.it> wrote in message
news:cn6bfb$lec$1_at_lacerta.tiscalinet.it...
> 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
>
>
Are you using bind variables and the array interface? Also I think for
objects you can have a .local object cache.
Jim
Received on Sat Nov 13 2004 - 21:21:30 CST
