Cache tunning for cardinality

This corresponds to your error in the 1st post:

Your application runs into this timeout. The spring framework you are using translates this timeout into a runtime exception. This is in my opinion not ideal. However this is a problem of the client you are using. You could ask there.

Regarding the 3s timeout: Is this configured by you or a default?