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.

Thanks,

Jerry

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

Triggers fire when posting.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Gerald W. McCaig" <gwmccaig@...>
To: <IBObjects@yahoogroups.com>
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
>
>




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


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/