XPost: comp.databases.ms-sqlserver   
   From: esquel@sommarskog.se   
      
   JENS CONSER (jens@e-sistrum.com) writes:   
   > We tested it by executing sql statements on the Query Analyzer   
   > on the VPN client (WIN XP built in) which is connected to the server   
   > through the tunnel.   
   >   
   > For example execution of the SELECT statement   
   > "select TOP 1000 * from Items" on the   
   > database trough the tunnel takes more than 30 times as much   
   > than the same execution on the server itself or within the   
   > server's local network.   
   >   
   > But we can make FTP downloads from our server through   
   > the tunnel with 600 KBit/s under same conditions   
   > so the bandwidth of the tunnel should not be the problem.   
      
   When you run QA directly on the SQL Server Box, or in your local   
   network, you have something like 100 MBit/s. 600 KBit/s is far   
   more than 30 times slower.   
      
   What speed is your VPN connection labeled at?   
      
      
   --   
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)