General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only