-
OUTPUT Performance Optimization
[This thread is associated with Part 18 of the SQL Credit series.]
Do you see something that would make the OUTPUT clause work as fast as the trigger?
Wrapping the DestinationTableBase INSERT and the HistoryTableBase INSERT in a transaction helped performance at the numbers I was running, but it's quite possible that at much larger rowcounts, the transaction would actually hurt performance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|