[ https://issues.apache.org/jira/browse/CASSANDRA-19529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17834868#comment-17834868 ]
Nicolas Henneaux edited comment on CASSANDRA-19529 at 4/8/24 10:06 AM: ----------------------------------------------------------------------- I think permissions are queried on each regular query, from tracing {{Executing single-partition query on role_permissions}}. Is it possible to activate some kind of caching to not query permissions for each query? was (Author: nicolas.henneaux): I think permissions are queried on each regular query, from tracing {{ Executing single-partition query on role_permissions}}. Is it possible to activate some kind of caching to not query permissions for each query? > Latency regression on 4.1 comparing to 4.0 > ------------------------------------------ > > Key: CASSANDRA-19529 > URL: https://issues.apache.org/jira/browse/CASSANDRA-19529 > Project: Cassandra > Issue Type: Bug > Components: Feature/Authorization > Reporter: Nicolas Henneaux > Priority: Normal > Fix For: 4.1.x, 5.0.x, 5.x > > Attachments: screenshot-1.png > > > When upgrading from Cassandra 4.0.10 to 4.1.3, I noticed an increase from > application point of view latency from ~8ms to ~15ms when upgrading to > Cassandra. The latency includes 3 simple queries (INSERT + SELECT (PK+CK) + > UPDATE) plus application overhead. > It has been investigated in CASSANDRA-18766 to realize it is not related. > I tested to downgrade to 4.1alpha1 and the latency regression is still there > with same value. > The version 4.1.4 has the same issue. > In a graph how it looks like > !screenshot-1.png! -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org