max number of triggers in a table

#1 (**permalink**) 04-09-2008, 06:51 AM

Hi,
I was wondering if there's a recommended maximum number of triggers in a
table?
Will having 3 triggers, one for insert or update, one for insert and one
for delete greatly impact performance?

Thanks,

J

#2 (**permalink**) 04-09-2008, 06:51 AM

On Wed, 2005-09-07 at 14:17, J wrote:
> Hi,
> I was wondering if there's a recommended maximum number of triggers in a
> table?
> Will having 3 triggers, one for insert or update, one for insert and one
> for delete greatly impact performance?

It's not the number so much as what they're doing.

If your trigger has some part causes a seq scan of a large table, then
it will be slow.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode