If new data keeps coming in but is only used for a short time before becoming completely inactive, that is a driver that could shift you to one approach instead of another. Data needs prioritization.
Learn more about What is the access frequency of the majority of the data