limitation of tc_positions table

mason chak9 months 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 Tananaev9 months ago

You can change the column type.