>Hi,
>I have the performance problem when I issue TABLEUPDATE() to my view It takes 10sec to update 2300 records. It work fine now once I delete for ...(since it is buffered table).
>
>Any suggestion?
Quite simply, 2300 records seems like a lot of records to process. I wouldn't expect to do it in a very short time.
If you want to do some processing on only a few records (perhaps 1, or 10), and it takes several seconds, then I would start worrying about a not-so-optimized process.
How long does it take to delete the selfsame 2300 records in the table, and without buffering?
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)