We are building a case management application that support many ad-hoc relationships among different record types. We are using data sync, but anticipate to exceed the 4M row limit eventually. What strategies should we consider for this? The documentation suggests adding source filters, which makes sense; but no longer will all the data be available in the record type. Do we move all queries to a!queryEntity but allow all writes to continue using a!writeRecords? If so, then we'd want to make sure all our record queries are in expression rules so they can be updated to queryEntity.
Discussion posts and replies are publicly visible
Difficult. Did you consider to implement a kind of data archival where you move data into a separate long term table structure?
Peter Lewis, this might be a use case you are interested in.
Data archival will eventually occur but we need to store some data for 25 years or longer.