[ACE-734] FN-UI Testing : Load MPLS Details is having Perf. Issue Created: 10/Mar/26 Updated: 13/Apr/26 Due: 10/Mar/26 Resolved: 17/Mar/26 |
|
| Status: | Reopened |
| Project: | ACE |
| Component/s: | FN |
| Affects Version/s: | FN 4.0.0.48 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Normal |
| Reporter: | Mbaye Lo | Assignee: | Zein Trabelsi |
| Resolution: | Not Fixed | Votes: | 0 |
| Labels: | Milestone2 | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
| Customer: |
OMAN-Tel
|
| Planned Start: | |
| Planned End: | |
| Product: | NEP |
| Description |
|
|
| Comments |
| Comment by Zein Trabelsi [ 11/Mar/26 ] |
|
improve report loading performance by replacing costly view joins with in-memory map lookups, adding targeted DB indexes on MPLS_DETAILS, NODEINTERFACE, NODESLOT and ACCESSCONFIGURATION tables, and adding @BatchSize annotations on Subscriber and SubscriberIp entities to eliminate N+1 queries |
| Comment by Zein Trabelsi [ 11/Mar/26 ] |
|
will be available on release 4.0.0.47 |
| Comment by Mbaye Lo [ 17/Mar/26 ] |
|
MPLS Details is returning empty page on .84t |
| Comment by Ayed Bada [ 30/Mar/26 ] |
|
Fix SQLGrammarException |
| Comment by Mbaye Lo [ 02/Apr/26 ] |
|
Not fixed, Exception error |
| Comment by Ayed Bada [ 03/Apr/26 ] |
|
Please retest the mentioned patch. Version 4.0.0.48 has been deployed |
| Comment by Mbaye Lo [ 07/Apr/26 ] |
|
MPLS Details report is opened, but a performance issue is still pending : 48s on .80 and 81s on .84 |
| Comment by Ayed Bada [ 13/Apr/26 ] |
|
Removed unnecessary calls and optimized processing by executing operations in parallel. Patch: 4.0.0.49 |