collection type stores list of Primary Keys in single column. It is better to determine that when the field value where Primary Keys (PK) are stored may reach the maximum length of field for the database implementation and entries may get truncated. In terms of the performance, collection type might be worse as the amount of entries would be grown, where in relation it is far more scalable and might be optimised.
