I have a column family that I'm using to archive records. They're mostly kept around for historical purposes. Aside from that, they're mostly considered deleted. It's probably going to be very rare that anyone reads from this table *ever*. I don't really even write to it that much.
Does anyone have advice for me as far as how (or if) I should tune this table with that in mind? My concern is less speeding up access to this table than it is making sure that it doesn't impact the performance of any other column families in any way. Here's the data from nodetool cfstat (although this table was just created a few days ago): Column Family: ArchivedLinks SSTable count: 1 Space used (live): 29580801 Space used (total): 97838786 Number of Keys (estimate): 93184 Memtable Columns Count: 7497 Memtable Data Size: 3223587 Memtable Switch Count: 11 Read Count: 0 Read Latency: NaN ms. Write Count: 139091 Write Latency: 0.007 ms. Pending Tasks: 0 Key cache: disabled Row cache: disabled Compacted row minimum size: 259 Compacted row maximum size: 372 Compacted row mean size: 311
