[CASSANDRA-5527] Deletion by Secondary Key - ASF JIRA
I agree with Jonathan, I don't see how we could make that efficient without having to read all the secondary key tombstones each time you read the row, which doesn't sound fun.
But as an aside, I'll note that another option for this is to use a secondary index. Now I know it's not read-free, but provided you do provide the partition key in the query, this will not be horribly inefficient either. And you'll exchange slightly slower writes for no hit whatsoever on reads, which I would suspect is a better trade-off more often than not for that kind of operation.
Read full article from [CASSANDRA-5527] Deletion by Secondary Key - ASF JIRA
No comments:
Post a Comment