| consecutive executions [message #654142] |
Wed, 27 July 2016 06:48  |
 |
bibhuti037
Messages: 2
Registered: December 2014
Location: Chennai
|
Junior Member |
|
|
I have changed one trigger in prod. I have added two select statements to select some data from table.
Previously one process was taking 30/35 seconds to process 1000 records, now it is taking 30/40 minutes after my change.
After my change first three thousand records are finishing in 1 minuts, but later it is takikg 40/50 minutes.
trigger t1.
procedure p1.
table tab1.
trigger t1 is on table tab1.
p1 will insert/update/delete records from/into tab1.
I have changed t1.
Previously
rows processed 9000 010052
rows processed 8000 010017
rows processed 7000 010000
rows processed 6000 005945
rows processed 5000 005925
rows processed 4000 005904
rows processed 3000 005841
rows processed 2000 005810
rows processed 1000 005710
Now, after change
rows processed 10000 062336
rows processed 9000 061742
rows processed 8000 052140
rows processed 7000 051114
rows processed 6000 045101
rows processed 5000 041121
rows processed 4000 035825
rows processed 3000 035729
rows processed 2000 035626
rows processed 1000 035427
Please help.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: consecutive executions [message #654191 is a reply to message #654185] |
Thu, 28 July 2016 02:24  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
bibhuti037 wrote on Thu, 28 July 2016 08:14Sorry .
Actually this is a production code. I cant put the whole code on this forum. 'Anonymise' the code.
Quote:Just I need some information on which direction I should look,that will help me to resolve this performance issue. It would appear that the performance issue is due to the change that you made. That is the direction in which you should be looking.
Quote:When this process What process? We have no idea what your process does, how do you expect anyone to be able to comment on it from a performance perspective?
Quote:completes and start from first it is working fine for some iterations. Then again it is becoming so slow. As above.
Quote:Previously it was taking 30 seconds, Now it was taken 53 mins for 1000 records. See above.
Quote:I have added just two select queries to take count for one combination. And if you back those changes out, does that resolve the performance issue?
Quote: If count there then take min(date) value for that combination. I don't know what you're saying here, is that what the extra code does?
Quote:Just help me on..on which area I should check. The bit that you changed that seems to have caused the problem.
Thanks in advance.
[/quote]
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
