Subject | Re: [ib-support] Update is Slow |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2003-06-05T11:35:22Z |
>I have thought trigger that cause the problem. However, the triggerWell, then we need a lot more information to help you, because this statement
>is nothing to do with this field. Moreover, the update performance
>does not improve although I remove the trigger.
>When I issued the below sql query:by itself should execute within second(s) when the table contains only a
> update HistCurr set IndiInitialized = 1
few thousand records.
Though there is one thing you haven't answered yet: What is the difference
between next transaction and oldest active transaction (OAT)? Another
question is if you run this statement by itself, or as part of a larger
operation, e.g. following a huge delete.
Set