Some clients connect fast, some slow 
Author Message
 Some clients connect fast, some slow

Hi, I am a Delphi developer developing with Delphi 3 and MSSQL Server 6.5

My problem is that some clients are very slow communicating with the server,
even through ISQLW.

I have two identical PCs, one is slow, and one is fast.
I have tried substituting one for the other to eliminate network problems,
but it doesnt help.

I think one has TCP/IP on it, and the other has IPX, (the fast one has
TCP/IP & IPX and the slow one just IPX) however removing TCPIP from the fast
one doesnt make it slow. and adding it to the slow one doesnt make it fast.

Has anyone ever seen this? or does anyone have any suggestions.

I would be VERY grateful if you could mail me as well as to the newsgroup,
as this seems to be a high traffic newsgroup and its impossible to tell if
anyone has answered.


Thanks in advance

George Styles



Wed, 10 Oct 2001 03:00:00 GMT
 Some clients connect fast, some slow

Have you checked the versions of the dll's involved?  I'm not familiar
with how Delphi talks to sql but I think it's via a native driver.  If
not, and you're using odbc, did you check to see that your DSN is setup
the same on both PC's.  In other words, is one using stored procs (the
check box on the configuration page) and the other not?

Andre

Quote:

> Hi, I am a Delphi developer developing with Delphi 3 and MSSQL Server 6.5

> My problem is that some clients are very slow communicating with the server,
> even through ISQLW.

> I have two identical PCs, one is slow, and one is fast.
> I have tried substituting one for the other to eliminate network problems,
> but it doesnt help.

> I think one has TCP/IP on it, and the other has IPX, (the fast one has
> TCP/IP & IPX and the slow one just IPX) however removing TCPIP from the fast
> one doesnt make it slow. and adding it to the slow one doesnt make it fast.

> Has anyone ever seen this? or does anyone have any suggestions.

> I would be VERY grateful if you could mail me as well as to the newsgroup,
> as this seems to be a high traffic newsgroup and its impossible to tell if
> anyone has answered.


> Thanks in advance

> George Styles



Fri, 12 Oct 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Slow connection on some clients, fast on others

2. Slow connection on some clients, fast on others

3. Slow connection on some clients, fast on others :(

4. Some clients slow, some fast w/ODBC

5. Slow BCP faster than fast BCP!?

6. Slow client connect

7. Very slow to connect the client over the network

8. SQL Server super slow when Novell Client For Netware is installed on client PC

9. Vb clients slow when more than 1 client log in

10. SQL 2000 client toosl slows down Windows 98 client machine

11. SQL Server super slow when Novell Client For Netware is installed on client PC

12. SQL Server super slow when Novell Client For Netware is installed on client PC


 
Powered by phpBB® Forum Software