So, I've been working on a Project where there is a very large volume of data that is kept and there is a relatively low amount of traffic, so it can afford more strain in terms of process/IO. I'd like to trade off some data-storage costs in exchange for processing costs.
There is an object that passes through multiple statuses which uses a little bit of different data at each step. If I use a process to transfer data from one record type to another, would it effectively cut down on data usage? In other words, does the overall record reserve data, while a record type only reserves a portion of that data?
Or is there some other stuff under the hood that makes this attempt moot?