Details
-
Type:
Bug
-
Status:
Ready for QA
(View Workflow)
-
Priority:
Normal
-
Resolution: Not Fixed
-
Affects Version/s: FN 4.0.0.48
-
Fix Version/s: None
-
Component/s: FN
-
Labels:
-
Customer:OMAN-Tel
-
Product:NEP
Description
FN-UI Testing : Load MPLS Details is having Perf. Issue 13s on OLD and 45s on New
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Links Hierarchy
- Transitions
- Trace
Removed unnecessary calls and optimized processing by executing operations in parallel.
Patch: 4.0.0.49
MPLS Details report is opened, but a performance issue is still pending :
48s on .80 and 81s on .84
Please retest the mentioned patch. Version 4.0.0.48 has been deployed
will be available on release 4.0.0.47
Show
Zein Trabelsi
added a comment - will be available on release 4.0.0.47
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
Show
Zein Trabelsi
added a comment - 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
Replace FN_NODE_INTERFACE with lightweight FN_MPLS_ACCESS_IFACE_V view (14.8s → 3.6s)