CODEWITHSUNDEEP
cassandrascylla
SilentCanon
SilentCanon

Reputation: 626

Will the compactions be fewer if partial columns are updated?

I have a table which has a lot of columns.

Does the database need fewer compactions if only partial columns are updated compared with that all columns are updated?

Upvotes: 1

Views: 65

Answers (2)

Avi Kivity
Avi Kivity

Reputation: 1410

Yes, each update is smaller, so memtables take more time to fill, and compaction happens less frequently.

Upvotes: 7

Manish Khandelwal
Manish Khandelwal

Reputation: 2310

Compactions depend on the strategy you have defined. In case of STCS and LCS lesser updates means less data and hence less compactions. For TWCS, compactions depend on time window you have defined.

Upvotes: 0

Related Questions