Subject RE: [IBO] HELP! Trigger Slow Down
Author Gerald W. McCaig
Hi Jason,

I am not sure what happened, but today when I updated to your latest
version, the slow down went away and everything is working fine again.
It was the strangest thing. We could not pinpoint where the problem was.

Anyway, it seems to be solved now.



-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Wednesday, July 17, 2002 4:54 PM
Subject: Re: [IBO] HELP! Trigger Slow Down

Triggers fire when posting.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Gerald W. McCaig" <gwmccaig@...>
To: <>
Sent: Wednesday, July 17, 2002 9:09 AM
Subject: [IBO] HELP! Trigger Slow Down

> Hello,
> I am having a major problem with an app. I recently created some
> triggers, and now some of my other screens that use this same table
> serious slow down problems on POST. It can take over a minute for the
> system to free up after I post the transaction.
> To test it, I have made the triggers inactive and then the other
> worked fine again. When I activated them, the slow down reappeared.
> I have tried running some updates on this same table in InterBase
> Workbench with the Triggers active. There was no problem. I have also
> created a sample app to recreate the problem, and there was no
> The difference between my sample app and my actual app is that I did
> use TIBOUpdateSQL Object. I am currently using version 4.2G ...
> Does anyone know if there is a problem with the update object or if
> there is something I can do to resolve this situation?
> Thank you in advance for your help
> Jerry

IB Objects - direct, complete, custom connectivity to Firebird or
without the need for BDE, ODBC or any other layer.
___ - your IBO community resource for Tech Info
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to