Sql Tuning [message #409594] |
Tue, 23 June 2009 04:20  |
prachij593
Messages: 266 Registered: May 2009
|
Senior Member |
|
|
If you are doing thousands of INSERTs, UPDATEs, or DELETEs, then triggers might not be the best way to handle whatever it is they are doing. Perhaps the whole thing could be packaged up into a high volume PL/SQL routine.
Why?
Thanks
|
|
|
|
|
Re: Sql Tuning [message #409638 is a reply to message #409637] |
Tue, 23 June 2009 06:48   |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Your question is far too vague. You make a statement that looks like it is a quote from somewhere, yet you do not reference it and then simply put Why? The only valid answer is to give you the answer to Life, The universe and everything in it i.e. 42. (Do a google search on the number 42 and the hitchhiker's guide to the Galaxy
[Updated on: Wed, 24 June 2009 03:14] Report message to a moderator
|
|
|
Re: Sql Tuning [message #409681 is a reply to message #409594] |
Tue, 23 June 2009 08:16   |
prachij593
Messages: 266 Registered: May 2009
|
Senior Member |
|
|
Quote: | If you are doing thousands of INSERTs, UPDATEs, or DELETEs, then triggers might not be the best way to handle whatever it is they are doing. Perhaps the whole thing could be packaged up into a high volume PL/SQL routine.
|
Could anyone help me understanding why?
The above line I have found in
Analysing problem SQL > Triggers
http://www.orafaq.com/tuningguide/
Many thanks..
[Updated on: Tue, 23 June 2009 08:18] by Moderator Report message to a moderator
|
|
|
Re: Sql Tuning [message #409720 is a reply to message #409681] |
Tue, 23 June 2009 11:08   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Because using a shovel is better for moving large amounts of dirt than using a teaspoon.
|
|
|
|