Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
VB and ADO performance problem accessing SQL Server over a WAN
2 views
Skip to first unread message
jh...@datalyzer.com
Sep 22, 2006, 4:26:16 PM9/22/06
to
I have a customer that is operating over a WAN on a T1 line. They are
experiencing unsatisfactory performance. (they have tried using ODBC
and OLE-DB connection) They gave the application 30% of the bandwidth a
put a monitor on it. It never used more than 10% of the available
bandwidth. They switched to an Access db with the same program doing
the same queries and saw the bandwidth usage bump up to near 100% for
short periods and they had satisfactory performance.
experiencing unsatisfactory performance. (they have tried using ODBC
and OLE-DB connection) They gave the application 30% of the bandwidth a
put a monitor on it. It never used more than 10% of the available
bandwidth. They switched to an Access db with the same program doing
the same queries and saw the bandwidth usage bump up to near 100% for
short periods and they had satisfactory performance.
I am using VB6 with ADO.
Using the SQL Server from a local network connection gives satisfactory
performance.
The amount of data transferred is really quite low, so the slow
performance is a mystery.
What could be creating this bottleneck in SQL Server?
0 new messages