sqlnet performance problem
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.eduReceived on Tue Apr 05 1994 - 06:49:33 CEST