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:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > 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.
