db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: Can I disable triggers
Date Fri, 07 Jul 2006 23:13:16 GMT
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.

View raw message