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

Query optimization - OES_SP_CheckPagelevelAccess

    Details

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

      Description

      This stored proc gets called for each and every action method call from entire system. We need to check if we can reduce its execution time.

        Attachments

          Issue Links

            Activity

            Transition Time In Source Status Execution Times
            Saurabh Sablaka (Inactive) made transition -
            New Request Pending for Approval
            1m 49s 1
            Saurabh Sablaka (Inactive) made transition -
            Pending for Approval Approved for Development
            2s 1
            Saurabh Sablaka (Inactive) made transition -
            Approved for Development In Development
            2s 1
            Saurabh Sablaka (Inactive) made transition -
            In Development In LB Testing
            7d 1h 22m 1
            Deepali Tidke (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            9d 21h 44m 1
            Deepali Tidke (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            2s 1
            Deepali Tidke (Inactive) made transition -
            Approved for Stage Stage Testing
            1s 1
            Deepali Tidke (Inactive) made transition -
            Stage Testing Pending for Production Approval
            2d 20h 48m 1
            Deepali Tidke (Inactive) made transition -
            Pending for Production Approval Approved for production
            1s 1
            Deepali Tidke (Inactive) made transition -
            Approved for production In Production Testing
            2s 1
            Deepali Tidke (Inactive) made transition -
            In Production Testing Production Complete
            7s 1
            Deepali Tidke (Inactive) made transition -
            Production Complete Closed
            2s 1

              People

              Assignee:
              deepalit Deepali Tidke (Inactive)
              Reporter:
              saurabh.sablaka Saurabh Sablaka (Inactive)
              Developer:
              Saurabh Sablaka (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date: