Steve Bosman wrote:
In my application I have the occasonal large transaction (100,000
records +) which runs on tables with database triggers, the triggers
write audit records and appear to be very slow processing a 1,000
records with triggers is about 10 times slower than without them (~90s
v ~9s). Is there a simple way of disabling and later enabling my
triggers for the duration of a particular transaction?
thanks in advance
Steve
Hi Steve -
I know of no way to disable a trigger. I think that dropping them
before the data load then recreating them is the only option.
