Uploaded image for project: 'mod-source-record-manager'
  1. mod-source-record-manager
  2. MODSOURMAN-846

Optimize Data Access Patterns To Update Job Execution Progress

    XMLWordPrintable

Details

    • Folijet Sprint 145
    • 2
    • Folijet
    • Nolana (R3 2022)

    Description

      A snapshot of metadata(job profile, etc) of a data import job, that is about to executed, is taken. This is stored in SRM and requested by other actors in the DI workflow(mod-inventory, SRS) to continue processing. This snapshot is taken from JSONB column in the database and can be quite large, at least 40KB. The database has to do string conversion of the data so this query takes longer than a regular query with relational columns. The request for this metadata is done multiple times over the course of a DI workflow so it is efficient to cache the metadata in the module instead of retrieving from the database over and over again.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                olamshin Olamide Kolawole
                olamshin Olamide Kolawole
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases