[ACE-578] API changeSubscriberNo has Performance Issue when the Subscriber has a trail Created: 16/Feb/26 Updated: 17/Feb/26 Due: 16/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 |
|
The subscriber we tested during the UAT session didn't have trail (24282815) and we had the following Time Excution on OLD and NAW : changeSubscriberNo 0,92s 1,62s But with subscriber with Trail (24220910), we are getting the following : <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.api.nep.mobinets.com/"> OLD: 0.95s NEW : Few minutes before the following error on New |
| Comments |
| Comment by Zein Trabelsi [ 17/Feb/26 ] |
|
instead of fetching service trails directly using hibernate (performance issue hops has relations with the ospconnection view) , fetch them using QueryDsl in Dtos |