Performance Issue with Database Connection
Your queries maybe inefficient or there
maybe something wrong with the VBA code.
If you post the code and queries you might get
a suggestion how to improve the speed.
RBS
"Ctal" wrote in message
.com...
I have an app that runs several queries depending on user input. The data
source is an Access database that's right at the 2GB limit. I stored
numerous queries in the database to cover all the possible user selections
from the Excel app. I'd read that stored queries are a bit faster than
just
sending the SQL script. Database resides on a LAN
Average time on these varies from 2 1/2 mins to 5 mins. From listening to
users (especially my boss) we need to improve this time.
I've tried every way I could think of to run this and nothing shortens the
time. 99.5% of the wait is while opening the recordsets.
My question:
Due to the size of this db (and its only one table but with 1.5M records)
would moving this to a SQL table and querying off of that speed this up?
I
do some other stuff against our main SQL tables and they are painfully
slow,
but that's with lots of joins and far more records. This would just be
the
one table.
|