ACE
  1. ACE
  2. ACE-590

API checkNewActivationP2PFeasibility has Performance Issue

        Details

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

          Description

          API checkNewActivationP2PFeasibility has Performance Issue

          Result are better than before (4.5s), but still not enough : 03s versus 2.3s

          <ser:checkNewActivationP2PFeasibility>
          <exchange>KWR1</exchange>
          <cab>999</cab>
          <dp>0001</dp>
          <dp2 />
          <nbOfPairs>1</nbOfPairs>
          <exchangeB>QUR2</exchangeB>
          <cabB>075</cabB>
          <dpB>0001</dpB>
          <dp2B />
          <nbOfPairsB>1</nbOfPairsB>
          <serviceTypeName>Digital data circuit with N/W</serviceTypeName>
          <serviceTechnology>Copper</serviceTechnology>
          <activeNeType>Multi Technology Access</activeNeType>
          <activeNeCategory>MSAN</activeNeCategory>
          <activeNeTypeB>Multi Technology Access</activeNeTypeB>
          <activeNeCategoryB>MSAN</activeNeCategoryB>
          </ser:checkNewActivationP2PFeasibility>

          <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
          <soap:Body>
          <ns2:checkNewActivationP2PFeasibilityResponse xmlns:ns2="http://server.api.nep.mobinets.com/">
          <return>
          <responseCode>0</responseCode>
          <responseMessage>SUCCESS</responseMessage>
          <trails>
          <exchange>KWR1</exchange>
          <exchange2>QUR2</exchange2>
          <hops>
          <order>0</order>
          <ospConnection>
          <changedBy>System</changedBy>
          <changedDate>2023-01-24T12:05:40+04:00</changedDate>
          <mainStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </mainStatus>
          <node1Code>0001</node1Code>
          <node1Model>INTERNAL TYPE</node1Model>
          <node1Name>KWR1_999_0001_DP</node1Name>
          <node1ObjectId>KWR1_999_0001_DP</node1ObjectId>
          <node1Type>MDF</node1Type>
          <node1TypeCategory>DP</node1TypeCategory>
          <node2Code>999</node2Code>
          <node2Model>INTERNAL CABINET</node2Model>
          <node2Name>KWR1_999_C</node2Name>
          <node2ObjectId>KWR1_999_C</node2ObjectId>
          <node2Type>MDF</node2Type>
          <node2TypeCategory>IDF</node2TypeCategory>
          <ospCnx xmlID="i21">
          <id>pair_1466409</id>
          <changedate>2023-01-24T12:05:40+04:00</changedate>
          <changedby>System</changedby>
          <insertBy>importer</insertBy>
          <insertdate>2020-11-07T15:02:12+04:00</insertdate>
          <netStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </netStatus>
          <subNetStatus xmlID="iD">
          <id>656F6FA9421F4E5FA7FA0927E0AEFCBE</id>
          <name>Spare pair - ordinary</name>
          </subNetStatus>
          <element1End>Front</element1End>
          <element1Id>mp_63092</element1Id>
          <element1Type>MdfPort</element1Type>
          <element2End>BACK</element2End>
          <element2Id>mp_2263047</element2Id>
          <element2Type>MdfPort</element2Type>
          <node2Id>Mdf_14078</node2Id>
          <nodeId>Mdf_38755</nodeId>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </ospCnx>
          <port1Key>1-85</port1Key>
          <port1Name>DP-1-85</port1Name>
          <port2Key>1-135</port2Key>
          <port2Name>Secondary-1-135</port2Name>
          <secondaryStatus xmlID="iD">
          <id>656F6FA9421F4E5FA7FA0927E0AEFCBE</id>
          <name>Spare pair - ordinary</name>
          </secondaryStatus>
          <site1ObjectId>Default Site</site1ObjectId>
          <site2ObjectId>Default Site</site2ObjectId>
          </ospConnection>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </hops>
          <hops>
          <order>1</order>
          <ospConnection>
          <changedBy>System</changedBy>
          <changedDate>2023-09-10T13:05:44+04:00</changedDate>
          <mainStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </mainStatus>
          <node1Code>999</node1Code>
          <node1Model>INTERNAL CABINET</node1Model>
          <node1Name>KWR1_999_C</node1Name>
          <node1ObjectId>KWR1_999_C</node1ObjectId>
          <node1Type>MDF</node1Type>
          <node1TypeCategory>IDF</node1TypeCategory>
          <node2Code>099-99</node2Code>
          <node2Model>MDFV</node2Model>
          <node2Name>KWR1_099-99_MV</node2Name>
          <node2ObjectId>KWR1_099-99_MV</node2ObjectId>
          <node2Type>MDF</node2Type>
          <node2TypeCategory>MDF</node2TypeCategory>
          <ospCnx xmlID="i31">
          <id>pair_1470054</id>
          <changedate>2023-09-10T13:05:44+04:00</changedate>
          <changedby>System</changedby>
          <insertBy>importer</insertBy>
          <insertdate>2020-11-07T15:02:12+04:00</insertdate>
          <netStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </netStatus>
          <subNetStatus xmlID="iA">
          <id>30E6169FE6BD47D587063658FEDD4839</id>
          <name>Free</name>
          </subNetStatus>
          <element1End>Front</element1End>
          <element1Id>mp_2190718</element1Id>
          <element1Type>MdfPort</element1Type>
          <element2End>BACK</element2End>
          <element2Id>mp_1278925</element2Id>
          <element2Type>MdfPort</element2Type>
          <node2Id>Mdf_13988</node2Id>
          <nodeId>Mdf_14078</nodeId>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </ospCnx>
          <port1Key>1-21</port1Key>
          <port1Name>Principal-1-21</port1Name>
          <port2Key>1-21</port2Key>
          <port2Name>Vertical-1-21</port2Name>
          <secondaryStatus xmlID="iA">
          <id>30E6169FE6BD47D587063658FEDD4839</id>
          <name>Free</name>
          </secondaryStatus>
          <site1ObjectId>Default Site</site1ObjectId>
          <site2ObjectId>M0007</site2ObjectId>
          </ospConnection>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </hops>
          <hops>
          <order>2</order>
          <ospConnection>
          <changedBy>importer</changedBy>
          <changedDate>2022-12-16T12:07:15+04:00</changedDate>
          <info>DATA</info>
          <mainStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </mainStatus>
          <node1Code>0203</node1Code>
          <node1Model>MDFH_Huawei_2</node1Model>
          <node1Name>KWR1_0203_H2_MH</node1Name>
          <node1ObjectId>KWR1_0203_H2_MH</node1ObjectId>
          <node1Type>MDF</node1Type>
          <node1TypeCategory>MDF</node1TypeCategory>
          <node2Code>10.126.10.208</node2Code>
          <node2Model>UA5000(IPMB)</node2Model>
          <node2Name>KWR1_04_IPMD_MAIN</node2Name>
          <node2ObjectId>10.126.10.208</node2ObjectId>
          <node2Type>MultiTechnologyAccess</node2Type>
          <node2TypeCategory>MSAN</node2TypeCategory>
          <ospCnx xmlID="i41">
          <id>pair_363923</id>
          <changedate>2022-12-16T12:07:15+04:00</changedate>
          <changedby>importer</changedby>
          <insertBy>importer</insertBy>
          <insertdate>2020-11-07T10:07:57+04:00</insertdate>
          <netStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </netStatus>
          <element1End>Front</element1End>
          <element1Id>mp_5990460</element1Id>
          <element1Type>MdfPort</element1Type>
          <element2End>Front</element2End>
          <element2Id>26F6903F08D749B7BA116361617FFC61-1/0/8/0/0</element2Id>
          <element2Type>NodeInterface</element2Type>
          <info>DATA</info>
          <node2Id>26F6903F08D749B7BA116361617FFC61</node2Id>
          <nodeId>Mdf_189193</nodeId>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </ospCnx>
          <port1Key>1-16</port1Key>
          <port1Name>0203016</port1Name>
          <port2Key>1/0/8/0/0</port2Key>
          <port2Name>HDSL 1/0/8/0/0</port2Name>
          <site1ObjectId>M0007</site1ObjectId>
          <site2ObjectId>M0007</site2ObjectId>
          </ospConnection>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </hops>
          <hops>
          <order>3</order>
          <ospConnection>
          <changedBy>importer</changedBy>
          <changedDate>2023-02-10T15:26:47+04:00</changedDate>
          <info>DATA</info>
          <mainStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </mainStatus>
          <node1Code>10.126.11.130</node1Code>
          <node1Model>UA5000(IPMB)</node1Model>
          <node1Name>QUR2_02_IPMB_MAIN</node1Name>
          <node1ObjectId>10.126.11.130</node1ObjectId>
          <node1Type>MultiTechnologyAccess</node1Type>
          <node1TypeCategory>MSAN</node1TypeCategory>
          <node2Code>50113</node2Code>
          <node2Model>MDFH_Siemens_H</node2Model>
          <node2Name>QUR2_50113_MH</node2Name>
          <node2ObjectId>QUR2_50113_MH</node2ObjectId>
          <node2Type>MDF</node2Type>
          <node2TypeCategory>MDF</node2TypeCategory>
          <ospCnx xmlID="i51">
          <id>pair_668078</id>
          <changedate>2023-02-10T15:26:47+04:00</changedate>
          <changedby>importer</changedby>
          <insertBy>importer</insertBy>
          <insertdate>2020-11-07T10:07:57+04:00</insertdate>
          <netStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </netStatus>
          <element1End>Front</element1End>
          <element1Id>7657EE6D00A94F25BEC30C90E8B1A610-1/0/21/0/0</element1Id>
          <element1Type>NodeInterface</element1Type>
          <element2End>Front</element2End>
          <element2Id>mp_5753874</element2Id>
          <element2Type>MdfPort</element2Type>
          <info>DATA</info>
          <node2Id>Mdf_203518</node2Id>
          <nodeId>7657EE6D00A94F25BEC30C90E8B1A610</nodeId>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </ospCnx>
          <port1Key>1/0/21/0/0</port1Key>
          <port1Name>HDSL 1/0/21/0/0</port1Name>
          <port1Status>AS</port1Status>
          <port2Key>1-25</port2Key>
          <port2Name>501132501B</port2Name>
          <site1ObjectId>M0003</site1ObjectId>
          <site2ObjectId>M0003</site2ObjectId>
          </ospConnection>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </hops>
          <hops>
          <order>4</order>
          <ospConnection>
          <changedBy>importer</changedBy>
          <changedDate>2023-02-10T15:26:47+04:00</changedDate>
          <mainStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </mainStatus>
          <node1Code>003-04</node1Code>
          <node1Model>MDFV</node1Model>
          <node1Name>QUR2_003-04_MV</node1Name>
          <node1ObjectId>QUR2_003-04_MV</node1ObjectId>
          <node1Type>MDF</node1Type>
          <node1TypeCategory>MDF</node1TypeCategory>
          <node2Code>075</node2Code>
          <node2Model>INTERNAL CABINET</node2Model>
          <node2Name>QUR2_075_C</node2Name>
          <node2ObjectId>QUR2_075_C</node2ObjectId>
          <node2Type>MDF</node2Type>
          <node2TypeCategory>IDF</node2TypeCategory>
          <ospCnx xmlID="i61">
          <id>pair_2520906</id>
          <changedate>2023-02-10T15:26:47+04:00</changedate>
          <changedby>importer</changedby>
          <insertBy>importer</insertBy>
          <insertdate>2020-11-07T15:02:12+04:00</insertdate>
          <netStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </netStatus>
          <subNetStatus xmlID="iD">
          <id>656F6FA9421F4E5FA7FA0927E0AEFCBE</id>
          <name>Spare pair - ordinary</name>
          </subNetStatus>
          <element1End>BACK</element1End>
          <element1Id>mp_1904939</element1Id>
          <element1Type>MdfPort</element1Type>
          <element2End>Front</element2End>
          <element2Id>mp_2554233</element2Id>
          <element2Type>MdfPort</element2Type>
          <node2Id>Mdf_47124</node2Id>
          <nodeId>Mdf_30958</nodeId>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </ospCnx>
          <port1Key>1-99</port1Key>
          <port1Name>Vertical-1-99</port1Name>
          <port2Key>1-49</port2Key>
          <port2Name>Principal-1-49</port2Name>
          <secondaryStatus xmlID="iD">
          <id>656F6FA9421F4E5FA7FA0927E0AEFCBE</id>
          <name>Spare pair - ordinary</name>
          </secondaryStatus>
          <site1ObjectId>M0003</site1ObjectId>
          <site2ObjectId>Dummy Site</site2ObjectId>
          </ospConnection>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </hops>
          <hops>
          <order>5</order>
          <ospConnection>
          <changedBy>importer</changedBy>
          <changedDate>2023-02-10T15:26:47+04:00</changedDate>
          <mainStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </mainStatus>
          <node1Code>075</node1Code>
          <node1Model>INTERNAL CABINET</node1Model>
          <node1Name>QUR2_075_C</node1Name>
          <node1ObjectId>QUR2_075_C</node1ObjectId>
          <node1Type>MDF</node1Type>
          <node1TypeCategory>IDF</node1TypeCategory>
          <node2Code>0001</node2Code>
          <node2Model>INTERNAL TYPE</node2Model>
          <node2Name>QUR2_075_0001_DP</node2Name>
          <node2ObjectId>QUR2_075_0001_DP</node2ObjectId>
          <node2Type>MDF</node2Type>
          <node2TypeCategory>DP</node2TypeCategory>
          <ospCnx xmlID="i71">
          <id>pair_1552392</id>
          <changedate>2023-02-10T15:26:47+04:00</changedate>
          <changedby>importer</changedby>
          <insertBy>importer</insertBy>
          <insertdate>2020-11-07T15:02:12+04:00</insertdate>
          <netStatus xmlID="i8">
          <id>6345B88251724EFF9BF4D145AB0FD686</id>
          <name>Spare pair</name>
          </netStatus>
          <subNetStatus xmlID="iD">
          <id>656F6FA9421F4E5FA7FA0927E0AEFCBE</id>
          <name>Spare pair - ordinary</name>
          </subNetStatus>
          <element1End>BACK</element1End>
          <element1Id>mp_4911403</element1Id>
          <element1Type>MdfPort</element1Type>
          <element2End>Front</element2End>
          <element2Id>mp_4403687</element2Id>
          <element2Type>MdfPort</element2Type>
          <node2Id>Mdf_148223</node2Id>
          <nodeId>Mdf_47124</nodeId>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </ospCnx>
          <port1Key>1-5</port1Key>
          <port1Name>Secondary-1-5</port1Name>
          <port2Key>1-7</port2Key>
          <port2Name>DP-1-7</port2Name>
          <secondaryStatus xmlID="iD">
          <id>656F6FA9421F4E5FA7FA0927E0AEFCBE</id>
          <name>Spare pair - ordinary</name>
          </secondaryStatus>
          <site1ObjectId>Dummy Site</site1ObjectId>
          <site2ObjectId>Dummy Site</site2ObjectId>
          </ospConnection>
          <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
          </hops>
          <serviceType>P2P</serviceType>
          <trailLabel>0</trailLabel>
          </trails>
          </return>
          </ns2:checkNewActivationP2PFeasibilityResponse>
          </soap:Body>
          </soap:Envelope>

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            Zein Trabelsi added a comment -

            Modify the findConnectionsByPorts query to use UNION ALL instead of OR .
            But it ,will still > 0.3 s

            Show
            Zein Trabelsi added a comment - Modify the findConnectionsByPorts query to use UNION ALL instead of OR . But it ,will still > 0.3 s
            Hide
            Permalink
            Mbaye Lo added a comment -

            No enhancement, still getting arround 4.5s of time execution

            Show
            Mbaye Lo added a comment - No enhancement, still getting arround 4.5s of time execution
            Hide
            Permalink
            Zein Trabelsi added a comment - - edited

            improved to < 2.1s . and that's maximum.

            Show
            Zein Trabelsi added a comment - - edited improved to < 2.1s . and that's maximum.
            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