ACE
  1. ACE
  2. ACE-616

getProcessVariableValue is having Performance issue 0.06s versus 2.3s

        Details

        • Type: Bug Bug
        • Status: Rejected Rejected (View Workflow)
        • Priority: Urgent Urgent
        • Resolution: Cancelled
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: FN
        • Labels:
          None Labels
        • Customer:
          OMAN-Tel

          Description

          getProcessVariableValue is having Performance issue 0.06s versus 2.3s

          <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.api.nep.mobinets.com/">
          <soapenv:Header/>
          <soapenv:Body>
          <ser:getProcessVariableValue>
          <!-Optional:->
          <woNo>4444000164</woNo>
          <!-Optional:->
          <variableName>AppType</variableName>
          </ser:getProcessVariableValue>
          </soapenv:Body>
          </soapenv:Envelope>

            Activity

            Hide
            Permalink
            Zein Trabelsi added a comment -

            same code executed in both systems.
            difference in performance due to flowable database size difference .
            in staging platform we made flowable database cleanup (FN_80)
            while in flowable database of 84 platform we didn't .
            find below comparaison between just 2 tables used when retrieving process variable both systems :
            old : ACT_RU_EXECUTION (35583) | ACT_RU_VARIABLE (475868)
            new : ACT_RU_EXECUTION (1113420) | ACT_RU_VARIABLE (12192874)

            Show
            Zein Trabelsi added a comment - same code executed in both systems. difference in performance due to flowable database size difference . in staging platform we made flowable database cleanup (FN_80) while in flowable database of 84 platform we didn't . find below comparaison between just 2 tables used when retrieving process variable both systems : old : ACT_RU_EXECUTION (35583) | ACT_RU_VARIABLE (475868) new : ACT_RU_EXECUTION (1113420) | ACT_RU_VARIABLE (12192874)
            Cancel

              People

              • Assignee:
                Mbaye Lo
                Reporter:
                Mbaye Lo
                Rejected By:
                Zein Trabelsi
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:
                  Planned Start:
                  Planned End:

                  Drag and Drop