Tracking query runtimes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey is there a way to track and measure run times of queries? I have a
boatload of queries and sub-queries running that I'd like to benchmark and
see if I can streamline.

Thanks,
 
You can use Access's own tuner to help design queries.
Tools--Analyze--Performance
Applying good design precepts should prevent most problems e.g. make sure
all joined columns are indexed.

Dorian
 
Thanks Dorian,

I don't think I currently have any join issues. I have vba kicking off a
bunch of action queries and exporting to excel files for distribution. Some
pc's running this application receive a "System Resource Exceeded" message
killing the app. I just need to identify which queries are bogging down
resources to see if temp table creations solve that issue.

Thanks again, I never thought to use the tuner.
 
Back
Top