View Issue Details

IDProjectCategoryView StatusLast Update
0002655SymmetricDSImprovementpublic2024-03-18 13:19
Reporterelong Assigned To 
Priorityhigh 
Status acknowledgedResolutionopen 
Product Version3.8.0 
Target Version3.15.5 
Summary0002655: Parameters and/or programmatic way to control type and size for sym_data, sym_trigger fields
DescriptionCreate parameters to control the data type and size for sym_data field: row_data, pk_data, old_data, and external_data. For row_data, pk_data, and old_data, they are by default CLOB, but the user might want them to VARCHAR with a size, which can increase the performance. For external_data, it is by default VARCHAR(50), but the user might want it to be larger.

This comes up in various database on various tables. sym_trigger is another spot where the table can be too "wide" for a database.
Tagsinstall

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-06-29 16:11 elong New Issue
2018-10-17 18:30 hanes Target Version => 3.10.0
2018-10-17 18:30 hanes Summary Parameters to control type and size for sym_data fields => Parameters to control type and size for sym_data, sym_trigger fields
2018-10-17 18:30 hanes Description Updated View Revisions
2018-10-17 18:30 hanes Status new => acknowledged
2018-10-29 16:54 hanes Priority normal => high
2018-12-05 19:01 hanes Summary Parameters to control type and size for sym_data, sym_trigger fields => Parameters or programmatic way to control type and size for sym_data, sym_trigger fields
2018-12-05 19:01 hanes Summary Parameters or programmatic way to control type and size for sym_data, sym_trigger fields => Parameters and/or programmatic way to control type and size for sym_data, sym_trigger fields
2019-03-14 12:39 admin Target Version 3.10.0 => 3.10.1
2019-04-23 13:46 elong Target Version 3.10.1 => 3.10.2
2019-04-24 12:56 elong Tag Attached: configuration
2019-04-24 12:57 elong Tag Attached: install
2019-04-24 12:57 elong Tag Detached: configuration
2019-05-08 12:51 admin Target Version 3.10.2 => 3.10.3
2019-06-24 17:45 elong Target Version 3.10.3 => 3.10.4
2019-08-09 19:41 elong Target Version 3.10.4 => 3.10.5
2019-10-31 14:59 admin Target Version 3.10.5 => 3.10.6
2019-11-14 19:45 elong Target Version 3.10.6 => 3.12.0
2020-05-26 12:27 elong Target Version 3.12.0 => 3.13.0
2021-11-02 20:52 elong Target Version 3.13.0 => 3.14.0
2022-07-25 16:20 elong Target Version 3.14.0 => 3.15.0
2023-09-25 19:45 admin Target Version 3.15.0 => 3.15.1
2023-10-06 13:29 elong Fixed in Version 3.15.1 =>
2023-11-14 20:25 elong Target Version 3.15.1 => 3.15.2
2023-12-15 20:19 admin Target Version 3.15.2 => 3.15.3
2024-02-05 13:55 admin Target Version 3.15.3 => 3.15.4
2024-03-18 13:19 elong Target Version 3.15.4 => 3.15.5