Project SimpleProject Type: software

Project Simple

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

Query performance - OES_SP_Get_EmployeeAttributeFields

    Details

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

      Description

      Call Stack:
      WORKTERRA.SqlHelper.ExecuteReader(:0)
      WORKTERRA.EmployeeData.GetEmployeeProfile(:0)
      WORKTERRA.EmployeeData.GetData(:0)
      WORKTERRA.Shared.WORKTERRAControllerAppTier.GetData(:0)

      StoredProc: OES_SP_Get_EmployeeAttributeFields

        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
            saurabh.sablaka Saurabh Sablaka (Inactive) created issue -
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to ST-175 [ ST-175 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: Development(10200)Level 1 values: In Progress(10206)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: On Hold(10207)
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Optimization changes are complete.
            Unit testing and Code review is pending.

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Optimization changes are complete. Unit testing and Code review is pending.
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment OES_SP_Get_EmployeeAttributeFields.sql [ 49436 ]
            Attachment OES_SP_GetOptionsForFieldsWithListControl.sql [ 49437 ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Nandkumar Prabhakar Karlekar,

            Had worked on this JIRA earlier.
            After discussion with Design team members had made optimization changes to stored procedure OES_SP_Get_EmployeeAttributeFields. Additional procedure was created to fetch options for fields with list control.
            Full fledged unit testing of this could not happen as new Invoice Management tasks got assigned.
            Following changes were done:

            Kindly take appropriate action for this JIRA.

            Thank you!

            cc: Satya

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , Had worked on this JIRA earlier. After discussion with Design team members had made optimization changes to stored procedure OES_SP_Get_EmployeeAttributeFields. Additional procedure was created to fetch options for fields with list control. Full fledged unit testing of this could not happen as new Invoice Management tasks got assigned. Following changes were done: OES_SP_Get_EmployeeAttributeFields.sql OES_SP_GetOptionsForFieldsWithListControl.sql Kindly take appropriate action for this JIRA. Thank you! cc: Satya
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Nandkumar [ satyap ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 26/May/17 11:00 PM
            • Time Spent:
              0.5h
               

              JIRA update for optimization changes done
              Discussion on JIRA assignment

            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 49639 [ 49639 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status New Request [ 10029 ] Product Backlog [ 10100 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Product Backlog [ 10100 ] 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 -

            we have considered this under WT-10577

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - we have considered this under WT-10577
            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 Product Backlog
            		540d 4h 38m 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Product Backlog Pending for Approval
            		7s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Pending for Approval Rejected
            		7s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Rejected Closed
            		19s 1

              People

              Assignee:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Reporter:
              saurabh.sablaka Saurabh Sablaka (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h