>Hi
>Thank you
>
>>>How long does it take to delete the selfsame 2300 records in the table, and without buffering?
>
>Hmm.. if I update the view without buffering, it take almost same time with buffered view - 10-15 secs. However, if I update the underlying table (my view join 3 tables, but only one table is updatable), it only take.. 1 sec
Maybe this is due to the additional overhead of sending each individual record back to the underlying tables.
If speed is really critical in this case, you might consider working directly with the table.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)