>>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
>
>I need buffering because the routine updates several tables with TRANSACTION.

You can use transactions without buffering.....