Subject | Re: [firebird-support] Many triggers causes slow connection |
---|---|
Author | Jonathan Neve |
Post date | 2005-07-28T20:14:29Z |
Ann W. Harrison wrote:
very flagrant. When I was testing, I started with one table: the
connection speed was normal. Once it worked, I added triggers for all
tables, and suddenly the connection speed, for the same table, was much
slower.
As others have suggested, it might be related to FIBPlus, rather than
Firebird itself... I'm not sure. I'll try with a different data access
component set, and see if the problem still occurs.
Thanks,
Jonathan Neve.
>Jonathan,The connection. I noticed this because I made a replication tool. It was
>
> Is it actually the connection or the first statement that's slow?
>
>
very flagrant. When I was testing, I started with one table: the
connection speed was normal. Once it worked, I added triggers for all
tables, and suddenly the connection speed, for the same table, was much
slower.
As others have suggested, it might be related to FIBPlus, rather than
Firebird itself... I'm not sure. I'll try with a different data access
component set, and see if the problem still occurs.
Thanks,
Jonathan Neve.