Re: Why would one queery hav 20x more sql*net message from client[idel] than other almost idenditcal query

On 1 Mar 2007 08:35:04 -0600, mistton <sdfds_at_dsfds.com> wrote:

>what is happening? is it totally how the client is working is ther nothing
>at the Oracle end?

network roundtrips are high? arraysize might need adjusting (but doesn't look like your code fetches more than one row at a time though).

If you shift your logic out of Java into PL/SQL, you might be able to solve your problem faster :)

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Mar 01 2007 - 22:37:47 CST