> > 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.

Transactions, no. But updating a million rows should be possible :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com