[ 
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

Reply via email to