Performance in a WAN

From: W. Blanken <100534>
Date: 1997/04/30
Message-ID: <01bc5542$2ef76920$f5b7aec7@wim-blanken>#1/1

We have developed an application using Forms 4.5 and Reports 2.5 which runs in a TCP/IP WAN, having 128 kb data lines. SQL*Net 2.2 is used. The performance of the forms is reasonable. However, the performance of some reports is much (up to 4 times) slower than on clients which have a 10 Mb connection. Monitoring of the data line, however, show that there is a maximum load of about 40 kb on the 128 kb lines. Does anyone have experience with such environments? Are there specific settings for SQL*Net of TCP/IP to use more of the line capacity and improve performance?

Wim Blanken Received on Wed Apr 30 1997 - 00:00:00 CDT