Ivan Prenosil wrote:

>>I've noticed that having many triggers in my database slows down the
>>connection considerably. A local connection takes several seconds.
>>
>>
>
>You are probably preparing all commands referencing all those tables
>immediately after connect, not when they are actually needed.
>
>

Well, no, I'm not. Perhaps however there are certain queries being sent
out by the data access components (FIBPlus), upon connection to the
database... Even so though, I don't see why adding triggers would make
it any worse. The same application, with only a few triggers had a
normal connection speed; with at least 3 triggers per table, the
connection was much slower...

Regards,
Jonathan Neve.


[Non-text portions of this message have been removed]