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

Research Spike: qry_ListInventoryDetails

    Details

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

      Description

      Details

      CFA is seeing slowdowns at the EOM related to this query.

      Questions

      1. Where is this stored proc used?
      2. Can we change the process around this proc to make it more efficient?
        1. Do all the places that call these queries need all the data provided by the query or can we trim it down?
      3. Can we make this query more efficient?
      4. What are the risks of making changes to this query?

        Attachments

          Issue Links

          is related to

          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

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-18357 Research Spike - List of Queries that can be Cached

          • Closed

          Customer Defect - CFAMX-17859 Nov 2021 EOM - Banking Transaction Blocking

          • Major - Major loss of function.
          • Done

          Customer Defect - CFAMX-17858 Nov 2021 EOM - Inventory Activity Report - qry_ListInventoryDetails

          • Major - Major loss of function.
          • Done

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jason.powell Jason Powell
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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