mwestra
MIS
- May 31, 2000
- 8
Forgive me if this doesn't make total sense...I'm fairly new to SQL Server and I'm hoping that I'm just missing some simple fix to speed things up.
We are currently converting all our Access databases over to SQL Server 2000. We're still keeping Access 2000 as our front end, but all the tables are getting linked via multiple trusted DSN-less ODBC connections. All code uses DAO which I understand is slower than ADO, but we don't have the time or resources to convert everything to ADO.)
The problem we are noticing while more and more of these databases get converted to SQL Server is that the ODBC connection seems to be quite slow. We've also noticed that the more tables that are in the database, the longer it takes to make the connection and if the database has a mixture of both ODBC and Jet linked tables, it takes even longer to connect. Once connected, we can scroll through the data rather quickly. Just making the connection takes a long time. (up to 15 seconds) If I just open a table, look at some records, close it, then reopen it, I have to wait another 15 seconds before the data shows up.
Does anyone have any suggestions as to how I can speed up these initial connections? Any help would be greatly appreciated.
We are currently converting all our Access databases over to SQL Server 2000. We're still keeping Access 2000 as our front end, but all the tables are getting linked via multiple trusted DSN-less ODBC connections. All code uses DAO which I understand is slower than ADO, but we don't have the time or resources to convert everything to ADO.)
The problem we are noticing while more and more of these databases get converted to SQL Server is that the ODBC connection seems to be quite slow. We've also noticed that the more tables that are in the database, the longer it takes to make the connection and if the database has a mixture of both ODBC and Jet linked tables, it takes even longer to connect. Once connected, we can scroll through the data rather quickly. Just making the connection takes a long time. (up to 15 seconds) If I just open a table, look at some records, close it, then reopen it, I have to wait another 15 seconds before the data shows up.
Does anyone have any suggestions as to how I can speed up these initial connections? Any help would be greatly appreciated.