I have a uses case where thousand of records need to be cached in document cache. We are doing this to avoid a sql lookup inside a map. The number of records can be a million. What will the best approach to go with. As of now we are using flow control shape with a few batches to store the records to the cache.
In this case a) will the cache get cleared after each flow?
b) Will the records get added to the existing records in the cache?