slow clients

[Ruudbern]

Hi,

i am using doa in a app witch fires lots of smal sql's after each other. Now on some networks its is slow from the client machine. If i run it from the server it's much faster. Any suggestions where to look or whta to change to speed op the client sqlnet connection?

 

[Marco Kalter]

Does this time include the connection time, or is te merely the SQL execution that is slow? Usually these differences are caused by connection delays, which in turn are caused by Oracle Net configuration issues.

 

[Ruudbern]

its the execution, it its up to 10 times slower. I also believe it's an Oracle Net configuration issues. Do you have any suggestions what i can do on the session component to pinpoint or optimize this?

 

[Marco Kalter]

Maybe you can test the basic network performance by pinging the database server machine from a PC with good and bad performance.

 

[Ruudbern]

The slowness seems to be an oci8 issue if i set useoci7 = true the same sql is much faster. 0,016 in stead of 0,125 in Oracle monitor.

 

[Marco Kalter]

That's odd. Do you have the same Oracle Net versions on the other clients?

 

[Ruudbern]

It's the same for all clients in a network. We have found 2 networks who have this problem (up to now)