View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003311 | SymmetricDS | Improvement | public | 2017-11-13 13:16 | 2019-04-24 16:47 |
Reporter | woehrl01 | Assigned To | |||
Priority | normal | ||||
Status | new | Resolution | open | ||
Summary | 0003311: MSSQL select varbinary from insert/deleted instead of origin table | ||||
Description | This 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. | ||||
Tags | dialect: sql-server, trigger | ||||