Subject Re: [IBO] HELP! Trigger Slow Down
Author Jason Wharton
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 have
> 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 screens
> 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 problem.
> The difference between my sample app and my actual app is that I did not
> 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