Hi all,
I got some keyspaces who becomes read-only after certain time, I would like to reduce the number of File descriptors and open files which consume a lot of memory , so I plan to compact keyspaces to a small number of sstables.My question is this, what would be the best practice in such a case? I am assuming that reducing it to 1 Data sstable might cause issues, as the summary file and the Index file will be quite large and demand a deeper scan on read.note: that these keyspaces are read-only , so I'm not concerned with many auto-compactions happen latter