SQL*Net v2 performance

From: Timo Haatainen <Timo.Haatainen_at_ttgroup.fi>
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

Original text of this message