Subject Re: [ib-support] Poor Network Performance
Author Helen Borrie
At 10:34 PM 26-12-01 -0600, you wrote:
>Greetings All,
>WinNT 4 SP6a (Server)
>win95, 98 workstations
>Interbase 6.01
>We're having poor network performance with IBConsole (As well as our
>application) across our network. The catch is that 20% of our machines work
>great. The other 80% are slow. Painfully slow as in about 40 seconds to
>open a table that has just two records in it. On the 20% that do work fine,
>the data retrival is instant. The connection to the GDB is slow as well as
>any SQL commands we run interactively. If we run the DB locally on these
>machines, the problem goes away. Can anyone think of anything we might be
>doing wrong that is causing a problem for some of our machines?

Immediate things...

Are these slow machines trying to connect via NetBeui instead of TCP/IP.

Alternatively, are they engaged in some form of networking operation involving NetBeui? or IPX/SX?

Another thing to look at is their network protocol stacks: remove IPX/SX altogether and tell them to play Quake on another network. :) No kidding, if IPX/SX is being used on that network, it will stupefy TCP/IP. Try to push TCP/IP up to the top of their stacks if you can.

If it is the Win95 workstations in particular, check whether they have the latest Plus! upgrade - slow connection often indicates that they are using the old Winsock 1.

Make sure that they are all connecting to OURSERVER:D:\ourpath\ourdatabase.gdb with *no* variation on this connection string format; no mapped drives, no drive designators that are missing the backslash after, no IP addresses.