Details

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

      Description

      reserveTrailsForSubscriber is having Performance issue 1.2s versus 2.2s

      <ns3:reserveTrailsForSubscriber xmlns:ns3="http://server.api.nep.mobinets.com/">
      <trails>
      <exchange>AZA1</exchange>
      <exchange2 />
      <hops>
      <order>0</order>
      <ospConnection>
      <bsw />
      <bswPair />
      <changedBy>System</changedBy>
      <changedDate>2025-08-18T13:34:20+04:00</changedDate>
      <info>24510463 24510669 24253130 24510258 24510865 24253800 24510362
      24512186 24518477 24518625, , 24518231, 24518947, </info>
      <mainStatus xmlID="i1">
      <id>75F5EA9B20D94E6BB7E004B6981275F6</id>
      <name>Working pair</name>
      </mainStatus>
      <node1Model>MA5600T</node1Model>
      <node1Name>AZA1_01_MA5600T_OLT</node1Name>
      <node1ObjectId>10.126.21.125</node1ObjectId>
      <node1Type>MultiTechnologyAccess</node1Type>
      <node1TypeCategory>OLT</node1TypeCategory>
      <node2Code>AZA1_01_MA5600T_OLT</node2Code>
      <node2Model>ODF</node2Model>
      <node2Name>AZA1_01_MA5600T_OLT_ODF</node2Name>
      <node2ObjectId>AZA1_01_MA5600T_OLT_ODF</node2ObjectId>
      <node2Type>ODF</node2Type>
      <node2TypeCategory>ODF</node2TypeCategory>
      <ospConnection xmlID="iNM">
      <id>pair_3589758</id>
      <changedate>2025-08-18T13:34:20+04:00</changedate>
      <changedby>System</changedby>
      <insertBy>importer</insertBy>
      <insertdate>2022-03-04T14:59:40+04:00</insertdate>
      <netStatus>i1</netStatus>
      <subNetStatus>i3</subNetStatus>
      <element1End>Front</element1End>
      <element1Id>A6FAD56E03C847A8830E7B19DEF78CEE-1/0/3/0/5</element1Id>
      <element1Type>NodeInterface</element1Type>
      <element2End>Front</element2End>
      <element2Id>op_717905</element2Id>
      <element2Type>OdfPort</element2Type>
      <info>24510463 24510669 24253130 24510258 24510865 24253800 24510362
      24512186 24518477 24518625, , 24518231, 24518947, </info>
      <node2Id>Odf_24294</node2Id>
      <nodeId>A6FAD56E03C847A8830E7B19DEF78CEE</nodeId>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </ospConnection>
      <port1Key>1/0/3/0/5</port1Key>
      <port2Key>15-7</port2Key>
      <secondaryStatus xmlID="i3">
      <id>1714F9599D9E4BBA88391048CBC864EF</id>
      <name>Working pair - dedicated</name>
      </secondaryStatus>
      <site1ObjectId>M0005</site1ObjectId>
      <site2ObjectId>M0005</site2ObjectId>
      </ospConnection>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </hops>
      <hops>
      <order>1</order>
      <ospConnection>
      <bsw />
      <bswPair />
      <changedBy>System</changedBy>
      <changedDate>2025-07-29T16:41:44+04:00</changedDate>
      <info> 24510669 24253807 24510362 24512186 24341312 </info>
      <mainStatus xmlID="i1">
      <id>75F5EA9B20D94E6BB7E004B6981275F6</id>
      <name>Working pair</name>
      </mainStatus>
      <node1Code>AZA1_01_MA5600T_OLT</node1Code>
      <node1Model>ODF</node1Model>
      <node1Name>AZA1_01_MA5600T_OLT_ODF</node1Name>
      <node1ObjectId>AZA1_01_MA5600T_OLT_ODF</node1ObjectId>
      <node1Type>ODF</node1Type>
      <node1TypeCategory>ODF</node1TypeCategory>
      <node2Code>064S</node2Code>
      <node2Model>Optical_Splitter_1:32_8</node2Model>
      <node2Name>AZA1_064S_FD</node2Name>
      <node2ObjectId>AZA1_064S_FD</node2ObjectId>
      <node2Type>Optical_Splitter</node2Type>
      <node2TypeCategory>FDH</node2TypeCategory>
      <ospConnection xmlID="iOM">
      <id>pair_3684653</id>
      <changedate>2025-07-29T16:41:44+04:00</changedate>
      <changedby>System</changedby>
      <insertBy>System</insertBy>
      <insertdate>2022-03-13T09:56:41+04:00</insertdate>
      <netStatus>i1</netStatus>
      <subNetStatus>i3</subNetStatus>
      <element1End>BACK</element1End>
      <element1Id>op_643773</element1Id>
      <element1Type>OdfPort</element1Type>
      <element2End>BACK</element2End>
      <element2Id>C5983082E7E94E7BA27B8723E56A40BE-1/1/1/0/1</element2Id>
      <element2Type>NodeInterface</element2Type>
      <info> 24510669 24253807 24510362 24512186 24341312 </info>
      <node2Id>C5983082E7E94E7BA27B8723E56A40BE</node2Id>
      <nodeId>Odf_24294</nodeId>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </ospConnection>
      <port1Key>13-11</port1Key>
      <port2Key>1/1/1/0/1</port2Key>
      <secondaryStatus xmlID="i3">
      <id>1714F9599D9E4BBA88391048CBC864EF</id>
      <name>Working pair - dedicated</name>
      </secondaryStatus>
      <site1ObjectId>M0005</site1ObjectId>
      <site2ObjectId>Dummy Site</site2ObjectId>
      </ospConnection>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </hops>
      <hops>
      <order>2</order>
      <ospConnection>
      <atbName>AZA1-064S-0003-17-COIL</atbName>
      <bsw />
      <bswPair />
      <changedBy>System</changedBy>
      <changedDate>2025-07-26T17:21:32+04:00</changedDate>
      <ftp>0003</ftp>
      <mainStatus xmlID="iK">
      <id>6345B88251724EFF9BF4D145AB0FD686</id>
      <name>Spare pair</name>
      </mainStatus>
      <node1Code>064S</node1Code>
      <node1Model>Optical_Splitter_1:32_8</node1Model>
      <node1Name>AZA1_064S_FD</node1Name>
      <node1ObjectId>AZA1_064S_FD</node1ObjectId>
      <node1Type>Optical_Splitter</node1Type>
      <node1TypeCategory>FDH</node1TypeCategory>
      <node2Code>0003</node2Code>
      <node2Model>INTERNAL TYPE</node2Model>
      <node2Name>AZA1_064S_0003_AP</node2Name>
      <node2ObjectId>AZA1_064S_0003_AP</node2ObjectId>
      <node2Type>ODF</node2Type>
      <node2TypeCategory>AP</node2TypeCategory>
      <ospConnection xmlID="iPM">
      <id>pair_3637209</id>
      <changedate>2025-07-26T17:21:32+04:00</changedate>
      <changedby>System</changedby>
      <insertBy>importer</insertBy>
      <insertdate>2022-03-11T15:26:54+04:00</insertdate>
      <netStatus>iK</netStatus>
      <subNetStatus>iM</subNetStatus>
      <element1End>BACK</element1End>
      <element1Id>C5983082E7E94E7BA27B8723E56A40BE-1/1/1/0/12</element1Id>
      <element1Type>NodeInterface</element1Type>
      <element2End>BACK</element2End>
      <element2Id>op_22618</element2Id>
      <element2Type>OdfPort</element2Type>
      <node2Id>Odf_1120</node2Id>
      <nodeId>C5983082E7E94E7BA27B8723E56A40BE</nodeId>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </ospConnection>
      <port1Key>1/1/1/0/12</port1Key>
      <port2Key>1-17</port2Key>
      <secondaryStatus xmlID="iM">
      <id>30E6169FE6BD47D587063658FEDD4839</id>
      <name>Free</name>
      </secondaryStatus>
      <site1ObjectId>Dummy Site</site1ObjectId>
      <site2ObjectId>Default Site</site2ObjectId>
      </ospConnection>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </hops>
      <serviceType>FiberCombo</serviceType>
      <tid>A0/3/5</tid>
      <trailLabel>GPON</trailLabel>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </trails>
      <subscriberNo>24510490</subscriberNo>
      <woNo>I1542540818</woNo>
      <override>true</override>
      </ns3:reserveTrailsForSubscriber>

        Activity

        Hide
        Zein Trabelsi added a comment -

        using query dsl method eq instead equalsIgnoreCase when fetching subscriber by subscriber_number which change query from where lower(subscriber0_.SUBSCRIBER_NUMBER)= to where subscriber0_.SUBSCRIBER_NUMBER= .
        Result: query time reduced from 0.3s to 0.002s.

        Show
        Zein Trabelsi added a comment - using query dsl method eq instead equalsIgnoreCase when fetching subscriber by subscriber_number which change query from where lower(subscriber0_.SUBSCRIBER_NUMBER)= to where subscriber0_.SUBSCRIBER_NUMBER= . Result: query time reduced from 0.3s to 0.002s.

          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