CookieMonster24 Posted November 18, 2003 Posted November 18, 2003 The company where i work at is using an access database and will eventually use a sql server. until then, i'm stuck using access. but my concern is that when i write a program in vb.net the speed with which my program connects to the db is quite slow. Please tell me that this won't be the case if i switch to a sql server. if not, is there anyway i can speed things up when i connect to an access db? Quote
Administrators PlausiblyDamp Posted November 18, 2003 Administrators Posted November 18, 2003 Do you mean it is slow to retreive data or slow on making the initial connection to the database? If the former a well written and designed SQL solution should improve speed. If the latter then the problem could be due to other factors - network speed, name resolution, size (and fragmentation) of the access DB. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
*Gurus* Derek Stone Posted November 19, 2003 *Gurus* Posted November 19, 2003 The ADO.NET provider for Microsoft SQL Server is faster than any of its predecessors, including ADO, DAO and the lesser-known RDO. It is only marginally slower than a direct, manually established network connection. Quote Posting Guidelines
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.