Frontend Access DB Too Slow
From: DDJ (johnson_at_milehi.com)
Date: 02/25/04
- Next message: Grant Stanley: "Re: Problem using ADO ConnectionPtr in a C++ class"
- Previous message: John: "Password protect a database using ADO"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Feb 2004 17:01:20 -0700
Our VB6 app uses an Access frontend (on local PC) and backend database (on a
network share). When starting the app, we set a main connection object
pointed to the frontend Access database (ADO with Jet 4.0 provider), and use
this main connection to open a few recordsets before the app's form opens.
When done in this manner, the app takes about 15 seconds to open and
retrieves about 50,000 bytes of data over the network while starting up.
When viewing the code in slow motion, each of the requested recordsets seem
to to take forever to open.
If we also create a dummy connection (before creating the main connection)
pointed directly to the backend Access database, which is not referenced
anywhere else in code, and which is closed as soon as the form opens, our
app takes about 2 seconds to load (much faster) BUT retrieves about
2,000,000 bytes of data over the network (a LOT more data).
Seems like a Catch-22 here. Can anyone think of a reason why this would be
happening. Since many of our users work over a WAN, the second option seems
way to expensive. On the other hand, taking 15 seconds to startup over a
fast ethernet connection is equally outrageous.
Thanks for any suggestions!
Dan
- Next message: Grant Stanley: "Re: Problem using ADO ConnectionPtr in a C++ class"
- Previous message: John: "Password protect a database using ADO"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
