SQL*Net v2 performance
Date: 1996/03/30
Message-ID: <315D38AB.422D_at_ttgroup.fi>#1/1
Hello,
I run a program on a database server connecting database over TCP/IP (!). The
response times depends heavily on bytes sent back from backend and on SQL*Net
version. Below are the results (values in column 'Bytes received' may not be
absolutely correct, but you can see the trend anyway):
Bytes Response time in seconds received Net v2 Net v1 -------------------------------- 65 kB 6 1 120 kB 11 1-2 290 kB 26 3
Why there is that big difference in response times between v1 and v2 connections? No matter how many times I rerun tests. And there is no other user programs running. The response time is about equal to v1 results when using local protocols (pipe, socket whatever they are). The platform is HP 9000 K100, HP-UX 10.01, Oracle 7.1.6.2.0, SQL*Net 2.1.6.1.0
Comments and suggestions are welcome.
Thanks,
Timo Haatainen
Received on Sat Mar 30 1996 - 00:00:00 CET