Project SimpleProject Type: software

Project Simple

Uploaded image for project: 'Project Simple'
  1. Project Simple
  2. ST-212

Query Performance - OES_SP_ACA_GetACADashboardDetails

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Component/s: Performance
    • Labels:
      None
    • Module:
      Platform - Performance
    • Reported by:
      Support
    • Item State:
      Development - On Hold
    • Issue Importance:
      Must Have

      Description

      Call Stack

      WORKTERRA.ACADashboard.SaveAndGetData(:0)
      WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)
      WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)
      WORKTERRA.ControllerAppTier.SaveAndGetData(:0)

      For More info
      https://rpm.newrelic.com/accounts/1155082/applications/13257194/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&app_trace_id=116b603-67b8cb81-2928-11e6-a1f2-f8bc12425d50

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. ST-175 Query Optimization for performance

          • High - Serious problem that could block progress.
          • New Request

            Activity

            Ascending order - Click to sort in descending order
            vikas.pawar Vikas Pawar (Inactive) created issue -
            vikas.pawar Vikas Pawar (Inactive) made changes -
            Field Original Value New Value
            Assignee Saurabh Sablaka [ saurabh.sablaka ]
            vikas.pawar Vikas Pawar (Inactive) made changes -
            Link This issue relates to ST-175 [ ST-175 ]
            Hide
            Permalink
            saurabh.sablaka Saurabh Sablaka (Inactive) added a comment -

            Marked as medium priority as this is related to ACA, we have currently focused on query optimization for areas under enrollment workflow.

            Show
            saurabh.sablaka Saurabh Sablaka (Inactive) added a comment - Marked as medium priority as this is related to ACA, we have currently focused on query optimization for areas under enrollment workflow.
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
            Priority High [ 2 ] Medium [ 3 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Assignee Saurabh Sablaka [ saurabh.sablaka ] Nandkumar [ satyap ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Rejected [ 10004 ]
            Hide
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            now we have created the jon for the same which will execute midnight and for complete day the same data will be cached

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - now we have created the jon for the same which will execute midnight and for complete day the same data will be cached
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Rejected [ 10004 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            New Request Pending for Approval
            		530d 6h 47m 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Pending for Approval Rejected
            		4s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Rejected Closed
            		50s 1

              People

              Assignee:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Reporter:
              vikas.pawar Vikas Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: