Hi,

>The table has a field BUILDING. When user changes the parent table of Buildings from BUILDING "MYBLD1" to "MYBLD2" this table has to be updated. So, yes, a bunch (130,000) records are updated with the same value.
>
>Please let me know if you see a way to reduce the time.

Would it be possible to do this *without* buffering?
Regards,
Viv