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
