Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-18357

Research Spike - List of Queries that can be Cached

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Resolution: Won't Develop
    • Affects Version/s: None
    • Fix Version/s: CFA 2022R2
    • Component/s: None
    • Labels:
      None
    • Sprint:
      2022.R2 New Features Sprint 1
    • SCRUM Team:
      Brotherhood of Mutants
    • Story Points:
      5
    • Work Type Classification:
      Sustaining

      Description

      What are some queries that we can cache in order to help prevent CPU spikes nd system slowdowns?

      • Of the top 10 most used queries, which ones create static data?

      AC

      1. A list of queries eligible for caching.

        Attachments

          Issue Links

          is related to

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-18003 Research Spike: qry_ListInventoryDetails

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-18348 Research Spike - List of Queries to Optimize

          • Closed
          led to these tickets

          Feature Request - CFAMX-18511 Opportunities to improve performance of SQL server

          • Major - Major loss of function.
          • Open
          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                Corey.Amend Corey Amend (Inactive)
                Reporter:
                jason.powell Jason Powell
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h
                  8h
                  Remaining:
                  0h
                  Logged:
                  Time Not Required
                  Not Specified

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.