Subject Re: [firebird-support] Re: FOR SELECT .. DO .. UPDATE is slow
Author Daniel Rail

At July 19, 2004, 15:33, clementdoss wrote:

> Neither of those fields are indexed :-(
> and int_mov_id is a primary key field.
> The update should be very fast.

Then the UPDATE is not your bottleneck, but the SELECT. But, the
SELECT might be trying to do some garbage collection at the same time.
Also, since there is no index on BLN_CALC, Firebird will do a table
scan for the SELECT.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (