Uploaded image for project: 'Instrument control development'
  1. Instrument control development
  2. INSTRM-2824

Consider partitioning large database tables

    XMLWordPrintable

    Details

      Description

      We currently don't partition any of our database tables. There are a few with a larger number of rows (e.g. mcs_data, cobra_target have ~150 million) for which partitions would give a performance boost on write/read.

      Evaluate if we want to go through the steps of partitioning tables, identify which tables might need it, do partitioning.

        Attachments

          Activity

            People

            • Assignee:
              wtgee Wilfred Gee
              Reporter:
              wtgee Wilfred Gee
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: