Paul,

>
>
> So we have a one million record update which fails on the last record. One
> million messages get send to request update of each record, and a
> provisional ok gets returned for 999,999. Then the last one fails, so we
> get 999,999 "transaction rolled back" messages to the same records. That is
> 2 million messages. With a UDP latency of 0.5 ms, that is 1,000 seconds for
> this statement, or about 16 minutes.
>

Or the failure is on the first update, but is not detected on the
local system. The transaction continues for another 999,999 rows,
fat, dumb, and happy...


Cheers,

Ann