speed of reports/queries in question

[Slez via AccessMonster.com]

A few of the queries/reports in my newly created database run very, very slow.
Often up to 15 seconds after a command. Not only running the queries/reports,
but making design changes also. The only common theme I can identify would
be that these are pulling data from externally linked tables. Could that
cause a slow running condition? Any suggestions?

I did run the Preformance Analyzer, but it didn't identify anything that
affects this issue.
In advance...Any ideas are appreciated!

 

[mnature]

If possible, try making a local copy of these external tables, and link to
the local tables, just for testing purposes. If the speed improves, then you
know it is the external tables causing the lag. If the speed doesn't
improve, then it is a local condition.

 

[Jerry Whittle]

Go to Tools, Options, General Tab and turn off Name Autocorrect on all of
your databases. IMHO it's a piece of do-do and the cause of many problems.
While there turn off Compact on Close if enabled. You'll be glad that you did.

Also temporarily turn off your virus checker for a quick test. If that makes
a positive difference there should be a way to exclude .md* files from
testing in the virus checker.

Also you might want to compare the criteria in the queries to the indexes in
the tables. If the Where clauses says something like EndDate > Now() and
there are more than a thousand records, putting an index on EndDate may speed
things up dramatically.