View Issue Details

IDProjectCategoryView StatusLast Update
0003311SymmetricDSImprovementpublic2017-11-13 08:16
Reporterwoehrl01Assigned To 
Status newResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0003311: MSSQL select varbinary from insert/deleted instead of origin table
DescriptionThis PR changes the trigger so that on MSSQL the value of blob fields are selected from the inserted/deleted virtual table instead of selecting it from the origin table.

This only works if it is a `varbinary(max)` field, so we filter based on that.

This reduces the access to the origin table and thus improves the trigger performance.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-11-13 08:16 woehrl01 New Issue