At least once a month, I get this question from a client:
We have big data, and we want to save money. We want to move the older data down to some kind of archives that will cost us less.
I ask exactly one followup question:
Are you willing to modify the app that queries the data, or do you want the users to still be able to query the old data in their existing screens and reports?
If you’re willing to modify the app – like having an “archive reports” section for when users wanna query the older data,