limitation of tc_positions table

mason chak 2 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 Tananaev 2 years ago

You can change the column type.