vb performance problem using ODBC to access SQL Server over a WANThis is a discussion on vb performance problem using ODBC to access SQL Server over a WAN within the ODBC forums in Framework and Interface Programming category; 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. I am using VB6 with ADO. Using the SQL Server from a local network connection gives satisfactory ... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
09-22-2006, 04:33 PM
| |||
| |||
 vb performance problem using ODBC to access SQL Server over a WAN 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. 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?  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 12:51 AM.
