db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Bosman" <stevebos...@gmail.com>
Subject Can I disable triggers
Date Fri, 07 Jul 2006 18:05:17 GMT
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

Mime
View raw message