search

apex-enterprise-patterns / fflib-apex-common

Common Apex Library supporting Apex Enterprise Patterns and much more!
BSD 3-Clause "New" or "Revised" License
903 stars 514 forks source link

Leverage Platform.Cache to speed up QueryBuilder SOQL creation #410

Closed rsoesemann closed 2 years ago

rsoesemann commented 2 years ago

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.

  1. Has anyone done and implemented that?
  2. Which risks are involved and how can they be mitigated?