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

At July 19, 2004, 14:16, clementdoss wrote:

> Hi,

> I'm using WI-V6.3.0.436 Firebird 1.5

> I am building a small stored procedure, and I need to update some
> records (7701). And I believe it's taking too much time. 10+ minutes.
> I don't know if this is the best way.
> I have commented out the "update TB_MOV ..." code out of it. And
> it's still very slow, so I guess that the update is not the issue,
> but this FOR SELECT is slow. Am I correct? Can a FOR SELECT be that
> slow?
> What would be the correct way to implement this code in FB?

How many records are there in the table TB_MOV?
If you execute the SELECT query by itself(outside of a SP), how long
does it take to execute and fetch all the records?

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