Re: slow ODBC connection Via VPN
- From: "Mike C#" <xyz@xxxxxxx>
- Date: Sun, 24 Dec 2006 01:16:19 -0500
I'd say contact the vendor; sounds like a 3rd party software issue based on
what you've said. Could be that they are pulling huge amounts of data
across every time, they could just have really poorly written queries in
their app or an inefficient database design, or any number of other
problems.
"jets" <nettecky@xxxxxxxxx> wrote in message
news:1166658356.820014.15320@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.
.
- References:
- slow ODBC connection Via VPN
- From: jets
- slow ODBC connection Via VPN
- Prev by Date: Slow Inserts over Internet using MFC
- Next by Date: Cannot Update Excel File Using ODBC
- Previous by thread: slow ODBC connection Via VPN
- Next by thread: Slow Inserts over Internet using MFC
- Index(es):
Relevant Pages
|
Loading
