[ACE-616] getProcessVariableValue is having Performance issue 0.06s versus 2.3s Created: 26/Feb/26  Updated: 27/Feb/26  Due: 23/Feb/26  Resolved: 27/Feb/26

Status: Rejected
Project: ACE
Component/s: FN
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Urgent
Reporter: Mbaye Lo Assignee: Mbaye Lo
Resolution: Cancelled Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Customer:
OMAN-Tel
Planned Start:
Planned End:
Rejected By: Zein Trabelsi

 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>

 Comments   
Comment by Zein Trabelsi [ 27/Feb/26 ]

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)

Generated at Wed Apr 15 09:53:25 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.