Limits on Collections

Hi @llKetanll

  • A single row can be up to 64MB in size.
  • You usually want to keep rows maximum in the 1MB - 2MB to have consistent latency.
  • Note that big collections are an anti pattern.
  • If the application warrants for a bigger number of values, it’s better to model the collection as another table.

The same is true for Cassandra. They support very big collections —> but they aren’t efficient —> you should not use them.

Also explained in docs: Collection data types (MAP, LIST, and SET) [YCQL] | YugabyteDB Docs

Regards,
Dorian
Technical Support Engineer