View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006219 | SymmetricDS | Improvement | public | 2024-01-31 16:59 | 2024-01-31 16:59 |
| Reporter | emiller | Assigned To | |||
| Priority | normal | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.16.0 | ||||
| Summary | 0006219: Make Sybase ASE triggers use an "insert ... select" statement instead of a cursor | ||||
| Description | Currently, all 3 Sybase ASE triggers use a cursor to insert into sym_data. While Sybase ASE's triggers are statement-level rather than row-level, it is possible to select all of the rows from the virtual tables (e.g. inserted) and insert them into sym_data using an "insert ... select" statement. It would be better to use the "insert ... select" approach because cursors perform worse and can cause unnecessary locks. | ||||
| Tags | dialect: sybase, trigger | ||||