Optimize PermissionChecker performance #13221
Labels
kind/task
Internal things, technical debt, and to-do tasks to be performed.
severity/P1
Has a major impact to usage or development of the system.
Milestone
Description
At this moment to during permission checking, we are making a couple of requests to the database. That makes some operation extremely ineffective #13131 (comment) . That is happing because L2 Cache for queries is disabled by default https://www.eclipse.org/eclipselink/documentation/2.6/concepts/cache003.htm query hash for
Worker.getByUserAndWorkspaceId
request.To enabled L2 cache for this type of operation, we can try to do two things
userId && workspaceId
https://wiki.eclipse.org/EclipseLink/UserGuide/JPA/Basic_JPA_Development/Caching/IndexesChe Server thread dump
The text was updated successfully, but these errors were encountered: