ACE
  1. ACE
  2. ACE-596

checkRequestNewActivationFeasibility has Performance Issue

        Details

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

          Description

          checkRequestNewActivationFeasibility has Performance Issue : 2s versus 5s

          <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.api.nep.mobinets.com/">
          <soapenv:Header/>
          <soapenv:Body>
          <ser:checkRequestNewActivationFeasibility>
          <!-Optional:->
          <requestId>526484</requestId>
          </ser:checkRequestNewActivationFeasibility>
          </soapenv:Body>
          </soapenv:Envelope>

            Activity

            Ascending order - Click to sort in descending order
            Mbaye Lo made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2026-02-18 24:00 (milestone: set planned start date to due date)
            Planned End 2026-02-18 24:00 (milestone: set planned end date to due date)
            Khaled Khalil made changes -
            Assignee Hassan Abdine [ habdine ] Zein Trabelsi [ ztrabelsi ]
            Zein Trabelsi made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Zein Trabelsi made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Hide
            Permalink
            Zein Trabelsi added a comment - - edited

            add index on Request table by request_no + use query dsl eq method instead equalsIgnoreCase.
            add index in service_trail_hop by OSP_CONNECTION, SERVICE_TRAIL_ID + remove lower(status.NAME) when fetching ospconnections .

            these changes would decrease response time from 5 to 2 s

            Show
            Zein Trabelsi added a comment - - edited add index on Request table by request_no + use query dsl eq method instead equalsIgnoreCase. add index in service_trail_hop by OSP_CONNECTION, SERVICE_TRAIL_ID + remove lower(status.NAME) when fetching ospconnections . these changes would decrease response time from 5 to 2 s
            Zein Trabelsi made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Zein Trabelsi [ ztrabelsi ] Mbaye Lo [ mbayel ]
            Mbaye Lo made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Hide
            Permalink
            Mbaye Lo added a comment -

            Fixed

            Show
            Mbaye Lo added a comment - Fixed
            Mbaye Lo made changes -
            Status QA In Progress [ 10015 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		3d 21h 41m 1 Zein Trabelsi 23/Feb/26 10:29 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		7s 1 Zein Trabelsi 23/Feb/26 10:29 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		48m 21s 1 Zein Trabelsi 23/Feb/26 11:18 AM
            To Be Released To Be Released Ready for QA Ready for QA
            		6m 39s 1 Khaled Khalil 23/Feb/26 11:24 AM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		2d 21h 44m 1 Mbaye Lo 26/Feb/26 9:09 AM
            QA In Progress QA In Progress Closed Closed
            		14s 1 Mbaye Lo 26/Feb/26 9:10 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

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

                Dates

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

                  Drag and Drop