Subject RE: [firebird-support] Slow stored procedure
Author Rick DeBay
Batching and committing ten updates at a time:

sending raw batch...175.24s sending CPR batch...0.1s committing...0.1s
done
sending raw batch...177.36s sending CPR batch...0.1s committing...0.1s
done

I guess the answer is never do updates on a large table without an index
(the raw table has no index, while the CPR table does).