[ACE-593] :reserveBONT has Performance Issue Created: 19/Feb/26  Updated: 25/Feb/26  Due: 18/Feb/26

Status: Ready for QA
Project: ACE
Component/s: FN
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Normal
Reporter: Mbaye Lo Assignee: Mbaye Lo
Resolution: Unresolved Votes: 0
Labels: Milestone2
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Customer:
OMAN-Tel
Planned Start:
Planned End:

 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>

 Comments   
Comment by Zein Trabelsi [ 25/Feb/26 ]

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

Generated at Wed Apr 15 09:57:49 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.