Hi
You should take this to a database newsgroup for more qualified solutions
(with all respect, spreadsheet collegues :-)
Have you experimented with indexes for performance gain ? If not then do so
(on a copy):
http://www.microsoft-accesssolutions...erformance.htm
Best wishes Harald
"Ctal" skrev i melding
.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.