Re: Qualitative method for performance effect of Oracle triggers

You got 10 hours. That's 36000 seconds. You need 100K records. That's roughly
3 records per second. Unless you intend to:

1- run the Britannica's full indexing in your triggers, or
2- run it on a steam-driven computer,

I wouldn't worry too much about the relative impact of triggers and any lengthy analysis.

Like I said: Unless.

PS: There is no such thing as a formula that will give you an analysis of impact of something you haven't defined to start with...

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Robert Roh" <rob_roh_at_hotmail.com> wrote in message news:c2e152a8.0311151025.431b7bcd_at_posting.google.com...


> We are studying the use of triggers on a system that expects 100,000

> records over a 10 hours period.

>

> Is there any way to measure the performance effect in a qualitative

> formulaic way as opposed to knowing that there will be some

> performance effect which you won't know until you test it

>