View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003311 | SymmetricDS | Improvement | public | 2017-11-13 13:16 | 2025-03-19 17:29 |
| Reporter | woehrl01 | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | won't fix | ||
| 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 | ||||
| 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 | |
| 2025-03-19 17:29 | mdrouard | Status | new => closed |
| 2025-03-19 17:29 | mdrouard | Resolution | open => won't fix |
| 2025-03-19 17:29 | mdrouard | Note Added: 0002726 |