Project SimpleProject Type: software

Project Simple

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

Query Performance -Bulk Insert AddChangeTermReport

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Component/s: Performance
    • Labels:
      None
    • Module:
      Platform - Performance
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Query Details
      BULK INSERT AddChangeTermReport FROM ? WITH ( FORMATFILE =?)

      Call Stack
      WORKTERRA.AddChangeTermReport.UpdateDatabase(:0)
      WORKTERRA.AddChangeTermReport.UpdateDatabase(:0)
      WORKTERRA.AddChangeTermReport.CreateDataForAddChangeTermReport(:0)
      WORKTERRA.AddChangeTermReport.Save(:0)
      WORKTERRA.AddChangeTermReport.SaveEnrollmentDataForConfirmationStatement(: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_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&tab-detail_116b603-295bb804-2536-11e6-a1f2-f8bc12425d50=database_queries&app_trace_id=116b603-295bb804-2536-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

            Transition Time In Source Status Execution Times
            Vikas Pawar (Inactive) made transition -
            New Request Pending for Approval
            		29d 3h 51m 1
            Vikas Pawar (Inactive) made transition -
            Pending for Approval Approved for Development
            		3s 1
            Vikas Pawar (Inactive) made transition -
            Approved for Development In Development
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Reopen in Local
            		3d 2h 32m 2
            Rakesh Roy (Inactive) made transition -
            Reopen in Local In Development
            		4d 20h 39m 2
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            		4d 15h 52m 3
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		14d 8h 20m 1
            Venkatesh Pujari (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            Approved for Stage Stage Testing
            		2s 1
            Rakesh Roy (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		10d 18h 33m 1
            Rakesh Roy (Inactive) made transition -
            Pending for Production Approval Approved for production
            		2s 1
            Rakesh Roy (Inactive) made transition -
            Approved for production In Production Testing
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		1d 55m 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		21s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              vikas.pawar Vikas Pawar (Inactive)
              Developer:
              Vikas Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: