ACE
  1. ACE
  2. ACE-734

FN-UI Testing : Load MPLS Details is having Perf. Issue

        Details

        • Type: Bug Bug
        • Status: Reopened Reopened (View Workflow)
        • Priority: Normal 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

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            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

            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
            Hide
            Permalink
            Zein Trabelsi added a comment -

            will be available on release 4.0.0.47

            Show
            Zein Trabelsi added a comment - will be available on release 4.0.0.47
            Hide
            Permalink
            Mbaye Lo added a comment -

            MPLS Details is returning empty page on .84t

            Show
            Mbaye Lo added a comment - MPLS Details is returning empty page on .84t
            Hide
            Permalink
            Ayed Bada added a comment -

            Fix SQLGrammarException
            Patch : 4.0.0.48

            Show
            Ayed Bada added a comment - Fix SQLGrammarException Patch : 4.0.0.48
            Hide
            Permalink
            Mbaye Lo added a comment -

            Not fixed, Exception error

            Show
            Mbaye Lo added a comment - Not fixed, Exception error
            Hide
            Permalink
            Ayed Bada added a comment -

            Please retest the mentioned patch. Version 4.0.0.48 has been deployed

            Show
            Ayed Bada added a comment - Please retest the mentioned patch. Version 4.0.0.48 has been deployed
            Hide
            Permalink
            Mbaye Lo added a comment -

            MPLS Details report is opened, but a performance issue is still pending :

            48s on .80 and 81s on .84

            Show
            Mbaye Lo added a comment - MPLS Details report is opened, but a performance issue is still pending : 48s on .80 and 81s on .84
            Hide
            Permalink
            Ayed Bada added a comment -

            Removed unnecessary calls and optimized processing by executing operations in parallel.

            Patch: 4.0.0.49

            Show
            Ayed Bada added a comment - Removed unnecessary calls and optimized processing by executing operations in parallel. Patch: 4.0.0.49
            Cancel

              People

              • Assignee:
                Zein Trabelsi
                Reporter:
                Mbaye Lo
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:
                  Planned Start:
                  Planned End:

                  Drag and Drop