db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Warner" <warnerconsult...@gmail.com>
Subject RE: Can I disable triggers
Date Fri, 07 Jul 2006 23:47:30 GMT
Actually, several commercial RDBMS do, including MSSQL and Sybase.  Sybase
just added it recently and it is a definite timesaver.


-----Original Message-----
From: Michael Segel [mailto:msegel@segel.com] On Behalf Of derby@segel.com
Sent: Friday, July 07, 2006 4:30 PM
To: 'Derby Discussion'
Subject: RE: Can I disable triggers

That actually would be a good feature.
Of course you'd want to be able to restrict the permissions of who can
enable/disable triggers.

I don't know of any RDBMS that allows it, but if you think about it, there
may be some times that you'd want to shut off a specific trigger.

> -----Original Message-----
> From: Stanley Bradbury [mailto:Stan.Bradbury@gmail.com]
> Sent: Friday, July 07, 2006 6:13 PM
> To: Derby Discussion
> Subject: Re: Can I disable triggers
> 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