[jira] [Created] (JAMES-3467) Experimental cache for DomainList calls

["Benoit Tellier (Jira)" <se...@james.apache.org>]

Benoit Tellier created JAMES-3467:
-------------------------------------

             Summary: Experimental cache for DomainList calls
                 Key: JAMES-3467
                 URL: https://issues.apache.org/jira/browse/JAMES-3467
             Project: James Server
          Issue Type: Improvement
          Components: data
    Affects Versions: master
            Reporter: Benoit Tellier


Hello there,

Upon my load testing campaign, I noticed `SELECT * FROM domains WHERE domain=xxx;` to be one of our "hot" query, both on JMAP load when JWT is used (because there is a lookup to the domain before granting access), but also backend processing.

This query load have a real impact (low but real) on the load we are able to handle.

On my use case (on premise in customer site) the domains (almost) never change, and, say, 10s propagation upon creation are acceptable.

Thus I would like to propose an opt-in cache mechanism to reduce the query load on Cassandra (but other implementation as well!). A cache on each node is ok, as the volume of domain is expected-to-be very low.

Of course, it should be explicitly configured, and disabled by default. Of course we should warn this is experimental.

Expected outcome is a 99% decrease of that query volume.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org