Subject | RE: [firebird-support] Many triggers causes slow connection |
---|---|
Author | Alan McDonald |
Post date | 2005-07-28T12:19:09Z |
> Hi all,I suspect something else at play here. I have DB's with many more tables and
>
> 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.
triggers than that (3, 4 times as many to start) and I do not notice
anything different in connection to those DB's with 3 tables and no
triggers.
What connection components/methods are you using?
Alan