optimize using in-memory caching

[moritzraho]

To reduce costs and enhance performance use an in-memory cache in front of the provider.

• read: check in memory cache -> miss -> check remote db

[purplecabbage]

This has been around for a while, should we attach any priority here @moritzraho ?

[moritzraho]

Let's close this for now as caching on the client might bring additional consistency issues