slow ODBC connection Via VPN
- From: "jets" <nettecky@xxxxxxxxx>
- Date: 20 Dec 2006 15:45:56 -0800
I have a custom third party shipping solution that interfaces with SQL
server. It connects with ODBC via a VPN to the SQL server. The
connection seams real slow to me, but maybe I am asking for to much?
The round trip from request of the client PC to the server and back
with the fields populated is 12 seconds when opening a new thread and 3
seconds when you request more information on the same thread. I have
added information into the Host and Lmhost files so I don't have to
do any DNS lookups. The response time with a 1000 byte packet is 59ms
and I am getting a throughput of 1.186 Mbps under load on the tunnel.
The VPN is a hardware IPsec tunnel (router to router). The server is a
windows 2000 box with twin 2.1 xeons with a gig of ram on an ultra wide
3 RAID 5 array with GP8.0 and SQL 2000 with all the Services packs and
updates on it. I would like to set this up on TS or Citrx but there is
no way to pass the scanner and scale information back to the server.
Any Ideas on how to speed this up would be greatly welcomed or is this
as good as it gets.
.
- Follow-Ups:
- Re: slow ODBC connection Via VPN
- From: Mike C#
- Re: slow ODBC connection Via VPN
- Prev by Date: Re: SQL Server 2005 ODBC - DateTime Problem
- Next by Date: Slow Inserts over Internet using MFC
- Previous by thread: Re: SQL Server 2005 ODBC - DateTime Problem
- Next by thread: Re: slow ODBC connection Via VPN
- Index(es):
Relevant Pages
|
