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

            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 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Assignee Saurabh Sablaka [ saurabh.sablaka ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Priority Medium [ 3 ] High [ 2 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Code Review Date 16/Sep/2016
            Dev Due Date 16/Sep/2016
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Assignee Saurabh Sablaka [ saurabh.sablaka ] Rakesh Roy [ rakeshr ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Deepali Tidke [ deepalit ]
            deepalit Deepali Tidke (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Hide
            deepalit Deepali Tidke (Inactive) added a comment - - edited

            Checked QE flow >> no unauthorized access found.

            Testing is in progress

            Show
            deepalit Deepali Tidke (Inactive) added a comment - - edited Checked QE flow >> no unauthorized access found. Testing is in progress
            Hide
            deepalit Deepali Tidke (Inactive) added a comment -

            Checked OE and New hire flow >> no unauthorized access found.

            Also checked all the pages from CA login >> no unauthorized access found.

            Show
            deepalit Deepali Tidke (Inactive) added a comment - Checked OE and New hire flow >> no unauthorized access found. Also checked all the pages from CA login >> no unauthorized access found.
            deepalit Deepali Tidke (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            Hide
            deepalit Deepali Tidke (Inactive) added a comment -

            Checked QE, OE and New hire flow >> no unauthorized access found.

            Also checked all the pages from CA login >> no unauthorized access found on stage.

            Show
            deepalit Deepali Tidke (Inactive) added a comment - Checked QE, OE and New hire flow >> no unauthorized access found. Also checked all the pages from CA login >> no unauthorized access found on stage.
            deepalit Deepali Tidke (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            deepalit Deepali Tidke (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            deepalit Deepali Tidke (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            deepalit Deepali Tidke (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            Hide
            deepalit Deepali Tidke (Inactive) added a comment -

            Checked QE, OE and New hire flow >> no unauthorized access found.
            Also checked all the pages from CA login >> no unauthorized access found on production.

            Show
            deepalit Deepali Tidke (Inactive) added a comment - Checked QE, OE and New hire flow >> no unauthorized access found. Also checked all the pages from CA login >> no unauthorized access found on production.
            deepalit Deepali Tidke (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)
            deepalit Deepali Tidke (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            deepalit Deepali Tidke (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            deepalit Deepali Tidke (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            deepalit Deepali Tidke (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            deepalit Deepali Tidke (Inactive) made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            deepalit Deepali Tidke (Inactive) made changes -
            Item State Parent values: Production Complete(10222) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            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: