sqlnet performance problem

From: Mark Citron <mcitron_at_hsc.usc.edu>
Date: 4 Apr 1994 21:49:33 -0700
Message-ID: <2nqqkt$lbb_at_hsc.usc.edu>


I have a forms30 application that retrieves about 20 rows. When I run it from the SCO machine (called server) that is also running the database engine, it takes less that 1 second to complete using the following command: runform30 myform username/passwd

If I run the form still on the machine that has the engine using runform30 myform username/passwd_at_T:server:orid it still takes one second. This seems the closest to a loopback situation which should account for the overhead of sqlnet (right?).

HOWEVER, if I run the form from a DIFFERENT SCO unix machine (called client) using the command
runform30 myform username/passwd_at_T:server:orid it takes from 10 to 12 seconds. This is a SIGNIFICANT increase. This time is after I have already logged on to the database with the form. It is just for executing the query. NOTE: I isolated both machines from the rest of the network so ethernet performance is optimum.

Any ideas about what is happening? Any parameters I can tune to speed things up? How much overhead time is involved in sqlnet. This may be the best reason I have heard NOT TO USE client/server. The performance is pretty bad, comparatively.

Any suggestions or insights are appreciated. Mark Citron
Childrens Hospital Los Angeles

-- 
Mark Citron
mark_at_neurosci.usc.edu
Received on Tue Apr 05 1994 - 06:49:33 CEST

Original text of this message