Posted by Erland Sommarskog on 06/06/05 18:19

Ryan (ryanofford@hotmail.com) writes:
> I've just inherited a system and have some concerns about the speed of
> connections to a remote server (SQL2000). If I do a simple select
> statement on the table below, it takes 14 minutes to retrive 6 million
> rows across a 2Mb line. Obviously it's a reasonable amount of data to
> retrieve, but I would have thought this would be quicker if I'm honest.
> Run locally, this is 50 seconds.

Hm, your maximum row size is 28 bytes. 28 * 6 million is 168 million.
2 MBit/s, means 250000 Bytes/s. 168 / 0.25 = 672. 672/60 = 11.2 minutes.
So it does not look unreasonable.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Can someone tell me what's wrong with this code?
• Prev in forum: Which has the best performance?
• Thread view: Re: Network performance for simple select statement

[Reply to this message]