Hi,

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.

[...snip...]

> 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. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)