[
https://issues.apache.org/jira/browse/JAMES-3467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17246345#comment-17246345
]
Benoit Tellier commented on JAMES-3467:
---------------------------------------
https://github.com/linagora/james-project/pull/4115 contributes this.
> 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
> Priority: Major
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
