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
          1.
          		 Create Test Scripts QA Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          2.
          		 Review Test Scripts QA Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          3.
          		 Deploy QA Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          4.
          		 Execute Test Cases QA Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          5.
          		 Functional Review with QA Dev Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          6.
          		 DIT Dev Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          7.
          		 Design Review Dev Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          8.
          		 Story Documentation Dev Task Done Unassigned

          0%
          Original Estimate - 0.5h
          Time Not Required
          9.
          		 Analyze top 10 most expensive and most used queries during EOM. Dev Task Done Corey Amend (Inactive)

          0%
          Original Estimate - 4h
          Time Not Required

            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.