View Issue Details

IDProjectCategoryView StatusLast Update
0002655SymmetricDSImprovementpublic2018-12-05 14:01
ReporterelongAssigned To 
Priorityhigh 
Status acknowledgedResolutionopen 
Product Version3.8.0 
Target Version3.10.0Fixed in Version 
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.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-06-29 12:11 elong New Issue
2018-10-17 14:30 hanes Target Version => 3.10.0
2018-10-17 14: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 14:30 hanes Description Updated View Revisions
2018-10-17 14:30 hanes Status new => acknowledged
2018-10-29 12:54 hanes Priority normal => high
2018-12-05 14: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 14: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