Details
-
Type:
Bug
-
Status:
Ready for QA
(View Workflow)
-
Priority:
Normal
-
Resolution: Unresolved
-
Labels:None Labels
-
Customer:OMAN-Tel
-
Complexity:Medium
-
REQUESTER:INTERNAL
Description
During the completion of any user task, FN currently executes an SQL query on the Flowable database to retrieve the task ID based on the woNo. This query can take from 2 seconds to more than 20 seconds to return the corresponding ID, which impacts performance.
To enhance this, we will leverage the two listeners associated with our human tasks (Create and Complete), which represent the two lifecycle events of each task. With this approach, the processing time is expected to be reduced to a maximum of 500 ms.
I have implemented this solution on the FN Cloud version to address the performance issue related to this subject. Once testing is completed successfully, the fix will be applied to SRD Cloud, FN, and the SRD Main Trunk.
Activity
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2026-02-24 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2026-02-24 24:00 (milestone: set planned end date to due date) |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Ayed Bada [ abada ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Summary | Improvement to Task Completion Performance | Performance Improvement for Task Completion |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 6 hours [ 21600 ] | |
| Worklog Id | 292199 [ 292199 ] |
| Baseline Start | 2026-02-24 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2026-02-24 24:00 (set baseline based of initial work logging) |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Time Spent | 6 hours [ 21600 ] | 1 day, 4 hours [ 43200 ] |
| Worklog Id | 292200 [ 292200 ] |
| Remaining Estimate | 0 minutes [ 0 ] | 1 hour [ 3600 ] |
| Time Spent | 1 day, 4 hours [ 43200 ] | 1 day, 3 hours [ 39600 ] |
| Worklog Id | 292199 [ 292199 ] |
| Remaining Estimate | 1 hour [ 3600 ] | 0 minutes [ 0 ] |
| Time Spent | 1 day, 3 hours [ 39600 ] | 1 day, 4 hours [ 43200 ] |
| Worklog Id | 292207 [ 292207 ] |
| Time Spent | 1 day, 4 hours [ 43200 ] | 1 day, 6 hours [ 50400 ] |
| Worklog Id | 292215 [ 292215 ] |
