[CAM-10749] Poor task query performance on Oracle - camunda JIRA

We couldn't load all Actvitity tabs. Refresh the page to try again.
If the problem persists, contact your Jira admin.

Type: Bug Report
Resolution: Unresolved
Priority: L3 - Default
Fix Version/s: None
Affects Version/s: 7.8.0, 7.11.0
Component/s: engine
Labels:
None

Prerequisites:

10k process instances, 7k active user tasks
authorization enabled
GRANT authorizations only
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

Problem:
Task count query takes more than 20s to run.

AT:
Query execution time should be sub-3s at least.

This is the controller panel for Smart Panels app

Loading...

Type: Bug Report
Resolution: Unresolved
Priority: L3 - Default
Fix Version/s: None
Affects Version/s: 7.8.0, 7.11.0
Component/s: engine
Labels:
None

Prerequisites:

10k process instances, 7k active user tasks
authorization enabled
GRANT authorizations only
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

Problem:
Task count query takes more than 20s to run.

AT:
Query execution time should be sub-3s at least.

This is the controller panel for Smart Panels app

is related to

CAM-11277 Improve Task Query Performance

Closed

mentioned in: Page No Confluence page found with the given URL.

Assignee:: Thorben Lindhauer

Reporter:: Tobias Metzke-Bernstein

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Created:: 20/Aug/19 8:05 AM

Updated:: 12/Oct/22 10:53 AM

Assignee:: Thorben Lindhauer

Reporter:: Tobias Metzke-Bernstein

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Created:: 20/Aug/19 8:05 AM

Updated:: 12/Oct/22 10:53 AM