Knowing ScyllaDB Limitations

ScyllaDB
1

Hi,

We are evaluating scylla for our internal filtering and sorting use case. We want to know the following:

  • How much data scylla supports per row. I see 20KB in the pricing calculator. Is it the limit?
  • How many index columns it supports per table.
  • Does performance degrade if per row data is large?
  • Is it real time DB or eventual consistent?

Thanks & Regards,
Abhishek

2

Hi @adpande

Thank you for reaching out!

  • How much data scylla supports per row. I see 20KB in the pricing calculator. Is it the limit?

There is no limit to the row size, but keep in mind, if the row/cell is too big might occur performance degradation and the CPU will take more time to process the data, increasing latency.

  • How many index columns it supports per table.

No limits, but should be used carefully to avoid performance degradation, remember that index or Materialized Views are also tables and should have small partitions as well.

  • Does performance degrade if per row data is large?

Yes, as mentioned the Scylla will take more time to process the rows - mostly for writes, read queries should be fine since we are a column-based database.

  • Is it real time DB or eventual consistent?

ScyllaDB is real-time with a predictable low-tail latency database and it is eventually consistent.

Here you can find some links to find out more:

1 Like