Uploaded image for project: 'Configuration Persistence Service'
  1. Configuration Persistence Service
  2. CPS-280

Address DB Performance Improvements Identified by Specialist

XMLWordPrintable

    • Icon: Story Story
    • Resolution: Done
    • Icon: Low Low
    • None
    • Istanbul Release
    • CPS-SPI Reference Impl
    • None

      This user story is to address the DB improvements identified in CPS-81:

      "I’ve gone diagonally through the schema and beside minor optimizations that I would not bother with – do you need the dataspace in the fragment table? Looks like that’s inherited from the anchor. It would chop one column and one index on your biggest table at the price of a fully indexed join through a relatively small table. Same story with schema set if possible, if we really get stuck with query performance we push additional fields in the tables later.

      Other than that  - LGTM, are you thinking already of partitioning the fragment table (a candidate would be anchor id)?"

      • Determine concrete changes required based on above feedback in a 'Implementation Proposal'
      • Agree changes with team
      • Implement changes (update liquibase DB version?)

       

       

       

       

            danielhanrahan Daniel Hanrahan
            ToineSiebelink Toine Siebelink
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: