I have a production system where the Selector classes and inside them the construction of complex QueryBuilder SOQL queries takes the most of the time.
I thought about using Platform Cache for that and storing the resulting query for later use.
- Has anyone done and implemented that?
- Which risks are involved and how can they be mitigated?