Performance problem connecting to SQL Server through ODBC over the internet
- From: jhall@xxxxxxxxxxxxx
- Date: 18 Dec 2006 14:51:21 -0800
I have cable modems on both ends of the connection.
I am using Access 2003 with ODBC linked tables to a MS-SQL Server 2000
db. The database is quite large with 2 million records in 130 tables.
But, the performance problems occur when returning as low as 100-250
records from one table with 12 fields of mostly integer and date fields
or less than 100 bytes per records, so <25,000 bytes.
The return time is >30 seconds.
If I connect to using the same ODBC connection through a VB6 app with
ADO I can get the same recordset in about 25 seconds, but it is still
way to slow.
I need to have < 5 seconds to be useable. The same query on a local
10MB/s network connection takes < 0.5 seconds.
I have heard various possible sources of the problem postulated in
other threads, but no one seemed to have solved it.
1. Packet size mismatch between internal network and internet. (to me
this would effect upload and downloads of files and we get 75KB/s up
and 220KB/s down)
.
- Prev by Date: SQL 2005 Express with Advanced Services: missing providers
- Next by Date: Re: SQL Server 2005 ODBC - DateTime Problem
- Previous by thread: SQL 2005 Express with Advanced Services: missing providers
- Next by thread: Re: SQL Server 2005 ODBC - DateTime Problem
- Index(es):
Relevant Pages
|
