--- In firebird-support@yahoogroups.com, "Epstein, Ed" <eepstein@c...>
wrote:

> I have a SP that is updating a field in about 3 million rows on a 11

million

> row table.

Ed, this is _very_ hard for FB if updated columns are indexed. Even
without indexes on updated columns it is hard for FB. Try to convert
logic of main loop to transfer it partly on client side to make
possible update 1000-10000 rows in one SP call and commit transaction
from client. FB have no and IMO never will have abilities to start and
commit transactions within SP.

Best regards,
Alexander.