Optimize issues ACT_VARINST queries without parameters

XMLWordPrintable

    • Type: Bug Report
    • Resolution: Fixed
    • Priority: L3 - Default
    • 1.0.0
    • Affects Version/s: None
    • Component/s: None
    • None

      Problem:

      On AWS, we see following query a number of times which takes a long time to complete:

      17-May-2017 13:04:40.261 WARNING [http-nio-127.0.0.1-8080-exec-9] org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport.reportFailedQuery Failed Query Report SQL=select RES.*
    from ACT_HI_VARINST RES
    order by RES.ID_ asc
    LIMIT ? OFFSET ?; time=60091 ms;

      They do not have any parameters, which results in querying the whole thing instead of process instance specific entities.

        This is the controller panel for Smart Panels app

              Assignee:
              Unassigned
              Reporter:
              Christian
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: