ACE
  1. ACE
  2. ACE-593

:reserveBONT has Performance Issue

        Details

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

          Description

          :reserveBONT has Performance Issue :

          0.3s on OLD versus 2.2s on NEW

          <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.api.nep.mobinets.com/">
          <soapenv:Header/>
          <soapenv:Body>
          <ser:reserveBONT>
          <!-Optional:->
          <exchange>XQ06</exchange>
          <!-Optional:->
          <subscriberNo>926957</subscriberNo>
          </ser:reserveBONT>
          </soapenv:Body>
          </soapenv:Envelope>

          <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
          <soap:Body>
          <ns2:reserveBONTResponse xmlns:ns2="http://server.api.nep.mobinets.com/">
          <return>
          <responseCode>0</responseCode>
          <responseMessage>SUCCESS</responseMessage>
          </return>
          </ns2:reserveBONTResponse>
          </soap:Body>
          </soap:Envelope>

            Activity

            Hide
            Permalink
            Zein Trabelsi added a comment -

            Fixed by adding indexes on NODEINTERFACE and NODESLOT to optimize FN_NODE_INTERFACE view from 1.8 s to 0.07

            Show
            Zein Trabelsi added a comment - Fixed by adding indexes on NODEINTERFACE and NODESLOT to optimize FN_NODE_INTERFACE view from 1.8 s to 0.07
            Cancel

              People

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

                Dates

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

                  Drag and Drop