Hello! I am using Cassandra 3.10. I have a counter table, with the following schema and RF=1
CREATE TABLE edges ( src_id text, src_type text, source text weight counter, PRIMARY KEY ((src_id, src_type), source) ); SELECT vs UPDATE requests ratio for this table is 0.1 READ vs WRITE rate, given by iostat is 100:1. Counter cache hit rate is 80%, so only for 20% UPDATE requests, the hard-disk is touched. I want to ask you which compation strategy is best for this table (SizeTieredCompactionStrategy or LeveledCompactionStrategy). Thank you, -- Octavian Rinciog --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org