Recommended TTL time for max. performance with DateCompactionStrategy?
I have a table which is going to be storing temporary search results. The results will be available for a short time ( anywhere from 1 to 24 hours) from the time of the search, and then should be deleted to clear up disk space.
This is going to apply to all the rows within this table.
What would be the recommended TTL time for this table, so that it works best with DateComactionStrategy, and causes the whole SSTable to get deleted rather than keep tombestones?