View Revisions: Issue #2655
| Summary | 0002655: Parameters and/or programmatic way to control type and size for sym_data, sym_trigger fields | ||
|---|---|---|---|
| Revision | 2016-06-29 16:11 by elong | ||
| Description | Create 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. | ||
| Revision | 2018-10-17 18:30 by hanes | ||
| Description | Create 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. |
||