0002655: Parameters and/or programmatic way to control type and size for sym_data, sym_trigger fields - SymmetricDS

Summary	0002655: Parameters and/or programmatic way to control type and size for sym_data, sym_trigger fields

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.

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.