View Issue Details

IDProjectCategoryView StatusLast Update
0003311SymmetricDSImprovementpublic2019-04-24 16:47
Reporterwoehrl01 Assigned To 
Prioritynormal 
Status newResolutionopen 
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.
Tagsdialect: sql-server, trigger

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-11-13 13:16 woehrl01 New Issue
2019-04-24 16:47 elong Tag Attached: dialect: sql-server
2019-04-24 16:47 elong Tag Attached: trigger