limitation of tc_positions table

mason chak2 years ago

as i can see, data type of id column in tc_positions table is signed int and the limitation of this type is 2,147,483,647 number of records.

  1. if my records count go higher what should i do?
  2. can i change id column type to BIGINT? in this case is there any performance issue?
  3. what is your suggestion to handle large amount of data?
Anton Tananaev2 years ago

You can change the column type.