Project SimpleProject Type: software

Project Simple

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

Query Performance - OES_SP_Export_GetChangeReasonAndDateTimeForElection

    Details

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

      Description

      Call Stack
      WORKTERRA.CommonExportRoutines.GetChangeReasonAndDateTimeForElection(:0)
      WORKTERRA.ExportProcessRowwise.FillDataIntoDataTable(:0)
      WORKTERRA.ExportProcessRowwise.ExportData(:0)
      WORKTERRA.ExecuteExportDTS.ExportData(:0)
      WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(:0)
      WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(:0)
      WORKTERRA.ControllerAppTier.Save(:0)

      For More Info
      https://rpm.newrelic.com/accounts/1155082/applications/13257194_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665222c22225d&tab-detail_116b603-645a4c60-2bb6-11e6-a1f2-f8bc12425d50=database_queries&app_trace_id=116b603-645a4c60-2bb6-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
            Link This issue relates to ST-175 [ ST-175 ]
            vikas.pawar Vikas Pawar (Inactive) made changes -
            Assignee Satya [ ID10004 ] Saurabh Sablaka [ saurabh.sablaka ]
            vikas.pawar Vikas Pawar (Inactive) made changes -
            Component/s Performance [ 10105 ]
            Component/s Platform [ 10006 ]
            Key WT-2891 ST-216
            Project WORKTERRA [ 10000 ] Project Simple [ 10400 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205)
            Hide
            Permalink
            saurabh.sablaka Saurabh Sablaka (Inactive) added a comment -

            Marked as medium priority as this is related to export, 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 export, we have currently focused on query optimization for areas under enrollment workflow.
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Priority High [ 2 ] Medium [ 3 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: Development(10200)Level 1 values: On Hold(10207)
            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 -

            frequancy of run is very low

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - frequancy of run is very low
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Resolution Won't Do [ 10001 ]
            Status Rejected [ 10004 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            New Request Pending for Approval
            		526d 7h 41m 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Pending for Approval Rejected
            		4s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Rejected Closed
            		39s 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: