Re: Performance in a WAN

On 30 Apr 1997 08:42:15 GMT, "W. Blanken" <100534,3512_at_compuserve.com> wrote:

>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

Have you looked at the performance of the report itself? I would look at the sql commands within the report. It seems odd that the forms with all the GUI information, data, etc would run faster that something that for the most part is purely character based. It may be that the system is actually running efficiently, but that the program/report is not. Try running the report on the server itself (if software allows).

What version of windows, what version,type of wan and what other connectivity software are you using?

scheuric_at_sprynet.com
-Sheilah Scheurich
DBA Received on Thu May 01 1997 - 00:00:00 CDT