Man, I know this is an old question because I remember seeing it some time ago but I have been searching and can't find it. Someone had written some code at one time or another to measure where the bottle necks are occuring within a DB. Anyone have any clue where that post is? Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Measuring DB performance
- Thread starter Montez659
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
I'd be interested too but I reckon the main bottlenecks will be found in one or both of the following:
Queries
Forms
Forms, over a network, can be a huge drain if you don't filter the records down before loading the form.
You could do something like:
Loop through all forms
Open normally
Open in data entry mode
Compare the time difference
Loop through all queries (except Action queries)
Time how long they take to run
Denis
Queries
Forms
Forms, over a network, can be a huge drain if you don't filter the records down before loading the form.
You could do something like:
Loop through all forms
Open normally
Open in data entry mode
Compare the time difference
Loop through all queries (except Action queries)
Time how long they take to run
Denis
Upvote
0
Similar threads
- Question
- Solved
