Re: SQL*Net Performance Problem
Date: 21 Feb 1994 21:29:18 GMT
Message-ID: <2kb93e$6v_at_nntp2.Stanford.EDU>
In article <CLLD5z.CnC_at_undergrad.math.uwaterloo.ca>,
Eric Mackie <eric_at_csg.uwaterloo.ca> wrote:
>I am having a problem with the performance of retrieving the results of
>queries using SQL*Net SPX for Windows. I have narrowed it down to a simple
>query issued from SQLDBA which returns 482 rows and takes 15 seconds when
>run from a workstation but only 3 seconds when run from the server. I am
>running a local ethernet network so I don't expect to see this performance
>degredation over the network.
>
>Can anyone who is using SQL*Net on a Novell network let me know what kind of
>performance they are seeing. I am trying to determine if SQL*Net is just slow
>or if I have a problem. Has anyone experienced this kind of problem? Any
>suggestions of things that I could try would be greatly appreciated. I am
>running out of ideas.
>
>My specific environment is an Oracle 7 server on a 486/50 running OS/2 V2.1,
>Microsoft Windows 3.1 on a 386/33 client machine connected via ethernet on a
>Novell V4 network. I have tried my tests using both SQL*Net 1.1 and Beta 2.0.
>
>Thanks
>
>Eric Mackie
>
Anyone who have the answers to this topics please mail to weng_at_leland.stanford.edu. Your reply will be very appreciated. Thanks a lot. Received on Mon Feb 21 1994 - 22:29:18 CET