Uploaded image for project: 'UX Product'
  1. UX Product
  2. UXPROD-2363

SRS Performance Improvements

    XMLWordPrintable

Details

    • Medium < 5 days
    • Very Small (VS) < 1day
    • Low
    • XXL < 30 days
    • There are 3 umbrellas included. T-short estimation can be higher then 30 days >60 days
    • Folijet
    • 106
    • R1
    • R2

    Description

      Feature for performance improvements for data coming into and going out of SRS.

      Broken into 3 umbrellas:

      Working with a library task force (liaison is spampell) to review and finalize requirements

      In addition to Folijet backend devs, will have dev help from William Welling/TAMU

      Metrics that we're trying to meet: spampell add preliminary metric goals

      TestRail: Results

        Attachments

          Issue Links

            defines

            Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. UXPROD-47 Batch Importer (Bib/Acq)

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Analysis Complete
            is defined by

            Task - A task that needs to be done. LIQUTIL-3 Initialize Repository

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MDEXP-199 Update dependency on SRS v4.0.0

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODDATAIMP-305 POST /data-import/uploadDefinitions long processing

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODPUBSUB-82 Use folio-liquibase-util for Liquibase schema management

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-91 Timeout when making GET requests to /source-storage/sourceRecords, part 2

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-92 Lookups in SRS for records by Instance UUID are timing out, part 2

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Umbrella - MODSOURCE-97 Improve performance and refactoring of SRS with standard DB tables

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-101 Refactoring of services to support new endpoints

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-102 Refactoring of DAO layer to support direct queries

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-106 When loading records, response times increase

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Umbrella - MODSOURCE-110 Improve performance when ingesting MARC records into SRS, including bulk loads

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Umbrella - MODSOURCE-121 Improve performance for receiving records from SRS

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-127 SPIKE: Investigate design for SRS performance improvements

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-129 Add Liquibase support for SRS

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-130 Create standard tables using LiquiBase

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-132 Performance: source-storage/records API call takes 50+ seconds with 1.3m records

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Umbrella - MODSOURCE-133 Extend the support of querying SRS via API

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-134 SPIKE: investigate request from all apps to SRS and design new endpoints

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-136 Change API to new version

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-137 Move logic from old services to the new

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-138 Asynchronous access to PgPool client

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-143 Use JOOQ in SRS

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-144 Delete old Dao\Service implementation

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-145 Remove matchedProfileId property from record.json schema

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-147 data-export takes more than 1 minute to export 1 inventory instance record

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-148 Missing index in mod_source_record_storage.records table

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-149 Get formatted records takes more than 5 seconds

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-150 Slow query > 1000 ms: get_record_by_external_id

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODSOURCE-152 Final verification migration scripts before release Q2 2020

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-154 Remove module Liquibase config schema

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-155 MARC Leader Status

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-156 Get Source Records By List of UUIDs

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODSOURCE-157 Filter by record state instead of delete query parameter

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-159 Generated SourceStorageSourceRecordsClient is not using query params

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURMAN-325 Update SRS client requests for v4

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. RMB-650 Client generator should support Date query parameter

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-654 Generated Client does not use the query params

            • TBD - To be determined
            • Closed

            Task - A task that needs to be done. UIDATIMP-548 Update Requests to SRS for v4

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                abreaux Ann-Marie Breaux
                abreaux Ann-Marie Breaux
                Ann-Marie Breaux Ann-Marie Breaux
                Taras Tkachenko Taras Tkachenko
                Oleksii Kuzminov Oleksii Kuzminov
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases