-
I have been trying to analyze a performance problem for days now.
What I am really stumped with is that the same query, filtering on the same columns(different data of course), same database takes significantly longer for one user and not the other and I cannot figure out what is wrong. Any ideas greatly appreciated. Thanks.
Here's the tkprof output for slow performace:
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 14 0.01 0.00 0 0 0 0
Execute 14 0.02 0.01 0 0 0 0
Fetch 14 41.13 51.64 85995 85999 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 42 41.16 51.65 85995 85999 0 1
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 8
tkprof output for fast performance:
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 10 0.01 0.00 0 0 0 0
Execute 10 0.00 0.00 0 0 0 0
Fetch 10 0.00 0.00 0 36 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 30 0.01 0.00 0 36 0 2
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 8
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|