Project SimpleProject Type: software

Project Simple

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

          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 ]
            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)
            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)
            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)
            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)

              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: