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
            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
            Hide
            Permalink
            Mbaye Lo added a comment -

            Fixed

            Show
            Mbaye Lo added a comment - Fixed
            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