Subject Re: [firebird-support] UPDATE: what am I doing wrong?
Author Daniel Rail

At July 18, 2003, 13:10, garyjones_mvm wrote:

> I have a query regarding the speed of using UPDATE in Firebird. I'm
> trying to update one table will values looked-up from another.
> Significantly perhaps, the performance monitor in IBExpert reports
> that the table PEOPLE is read around 40 million times in executing
> the procedure. (It's probably no coincidence that 40
> million=5000x8000).

> So, what am I doing wrong, and how can I get my UPDATEing to work
> faster?

Do you have an index on the field "id" in the table "people"? If not,
try creating an index on that field.

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