troubleshooting Question

Access Query taking long to run

Avatar of K-9
K-9 asked on
Microsoft Access
12 Comments1 Solution706 ViewsLast Modified:
I have a split database, backend is on a server.  Tables are linked.  I'm having an issue with one particular query/form.  There are two tables, callserv and mastername.  Each table holds about 50,000 records.  They are joined by callserv.cid -> mastname.nameid.  callserv.cid is a unique value, where as mastname.nameid can have duplicate values.

When running the query by itself it is taking around 10 seconds to run, when I open the form that uses this query, the form takes about 10 seconds to run the first time, however subsequent times the form opens instantly.

Normally I wouldn't mind, but this form is used very heavily and I would like it to open instantly the first time.

I have the query sorting as well, based on two fields (incnoyear and incnoseq) which are numbered fields.  I have tried all sorts of things, even running the query at the beginning of my application, which then results in the form opening right away, however the application seems like it's 'hung' for 10-15 seconds which is unacceptable.

I'm at a loss and was hoping one of you geniuses could help me out.  I could post the code/tables if needed.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros