darkhelmutis
New member
- Local time
- Today, 15:14
- Joined
- Nov 11, 2008
- Messages
- 3
I am looking for some guidance on how to calculate the amount time it takes for queries to run in two different version of a database.
So, from the switch board I select which action to take and would like to have something (a macro I presume) to capture the time at the start of the query. When the query finishes, the macro should capture the time and then subtract the start time to figure out how long it took.
Is this the best way to do this? Or does Access 2007 have some built in features to measure performance in this way? If more information is required, I will gladly provide it. Thanks!
FYI:
One database suffers from spreadsheet syndrome i.e. fewest tables possible, no relationships, etc. Performance is adequate until the record count hits a certain level, then drops to barely usable levels.
The other database will be a reworked version (hopefully) in 1st normal form (i don't have enough time to refine it further). It should perform the same functions, but in theory run much faster.
So, from the switch board I select which action to take and would like to have something (a macro I presume) to capture the time at the start of the query. When the query finishes, the macro should capture the time and then subtract the start time to figure out how long it took.
Is this the best way to do this? Or does Access 2007 have some built in features to measure performance in this way? If more information is required, I will gladly provide it. Thanks!
FYI:
One database suffers from spreadsheet syndrome i.e. fewest tables possible, no relationships, etc. Performance is adequate until the record count hits a certain level, then drops to barely usable levels.
The other database will be a reworked version (hopefully) in 1st normal form (i don't have enough time to refine it further). It should perform the same functions, but in theory run much faster.
