Subject | Many triggers causes slow connection |
---|---|
Author | Jonathan Neve |
Post date | 2005-07-28T12:12:37Z |
Hi all,
I've noticed that having many triggers in my database slows down the
connection considerably. A local connection takes several seconds. This
isn't a big issue, but it would be good if there was some work-around or
fix.
Has anyone else noticed this? I noticed this on a database I have with
214 triggers (at least 3 per table), using IB 6.0. If anyone else has a
database with a comparable number of triggers, can you reproduce this
problem with a more recent version of FB?
Thanks!
Jonathan Neve.
I've noticed that having many triggers in my database slows down the
connection considerably. A local connection takes several seconds. This
isn't a big issue, but it would be good if there was some work-around or
fix.
Has anyone else noticed this? I noticed this on a database I have with
214 triggers (at least 3 per table), using IB 6.0. If anyone else has a
database with a comparable number of triggers, can you reproduce this
problem with a more recent version of FB?
Thanks!
Jonathan Neve.