CODEWITHSUNDEEP
cassandracqlcassandra-3.0
Sahibzada
Sahibzada

Reputation: 153

Does time to live (ttl) affect or decrease performance?

i am using cassandra and using ttl (time to live) in queries for auto delete rows. My question is that, is TTL affect performance?

Upvotes: 0

Views: 364

Answers (2)

Andrew Mo
Andrew Mo

Reputation: 1463

Generally use of a TTL makes little to no difference in the performance (i.e. response time) of CQL queries.

It is worth nothing, however, that use of the optional TTL value when inserting or updating a record requires additional storage than the same record without a TTL. This can become relevant if/when you are creating many records with long TTL periods.

You can learn more about estimating the size of records stored in Cassandra here:

Upvotes: 1

Carlos Monroy Nieblas
Carlos Monroy Nieblas

Reputation: 2283

No, it doesn't affect the performance in a measurable way.

Upvotes: 1

Related Questions