>it seems to me you are doing double work for no reason
>once updating the view and then committing the changes you may want to look at SQL Passtrough (SQLEXEC) for this specific update

... I don't understand where's the double work. Can you be a little more specific, please? I never used SQL Passthrough. Thanks.

>Also it is not clear to me if you tried to change the BatchUpdateCount of the view if you didn't you may want to try that as well

Yes, I did. I tried with 1 and 100 and the speed is almost the same (I believe that the small differences are due to other OS processes).

Vlad