Project SimpleProject Type: software

Project Simple

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

Query Performance - OES_SP_Get_FormBuilderAttributeFields

    Details

    • Type: Enhancement
    • Status: New Request
    • Priority: High
    • Resolution: Unresolved
    • Component/s: Performance
    • Labels:
      None
    • Module:
      BenAdmin - EDS
    • Reported by:
      Support
    • Item State:
      Development - On Hold
    • Issue Importance:
      Must Have

      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
          Hide
          Permalink
          prasanna Prasanna Karlekar (Inactive) added a comment -

          New Relic Log for Load Test carried on Local Performance machine on 16 June 2016:

          https://rpm.newrelic.com/accounts/1353506/applications/24434194/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e47657444617461222c22225d&app_trace_id=177be6f-ca5e3548-33d7-11e6-8eb5-f8bc12425d4c

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - New Relic Log for Load Test carried on Local Performance machine on 16 June 2016 : https://rpm.newrelic.com/accounts/1353506/applications/24434194/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e47657444617461222c22225d&app_trace_id=177be6f-ca5e3548-33d7-11e6-8eb5-f8bc12425d4c
          Hide
          Permalink
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Suhas Joshi

          Keeping this ticket on hold as we will have to remap the logic for this stored procedure and check for Performance benefit.

          We have tried following till now:

          • Index creation on tables FieldsLabel_Multilingual, MemberFieldRights (Company and Online Enrollment both), Employee_FormData. Indexing done on Local as well as Production Load Test companies.
          • Reindexing on all tables for Load test companies
          • Query changes stored procedure. Could not see any improvement hence reverted.
          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Suhas Joshi Keeping this ticket on hold as we will have to remap the logic for this stored procedure and check for Performance benefit. We have tried following till now: Index creation on tables FieldsLabel_Multilingual, MemberFieldRights (Company and Online Enrollment both), Employee_FormData. Indexing done on Local as well as Production Load Test companies. Reindexing on all tables for Load test companies Query changes stored procedure. Could not see any improvement hence reverted.

            People

            Assignee:
            vikas.pawar Vikas Pawar (Inactive)
            Reporter:
            prasanna Prasanna Karlekar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated: