jitsu icon indicating copy to clipboard operation
jitsu copied to clipboard

Change primary keys SQL types to varchar

Open xtreding opened this issue 3 years ago • 0 comments

Problem

At present Jitsu creates string columns with TEXT or character varying(65535) SQL type even if they are used in the primary key constraint. Downside: data type text requires more space in RAM and on disk and it is slower to process.

Solution

  • [ ] Change all big strings types such as TEXT or character varying(65535) to VARCHAR(255).
  • [ ] Move size of VARCHAR - 255 into a constant

xtreding avatar Feb 03 '22 17:02 xtreding