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

Add some indexes for common cobra/mcs/ag/target joins

    XMLWordPrintable

    Details

    • Sprint:
      Eng13Oct

      Description

      One common set of queries is the family of select xxx from cobra_match where mcs_frame_id == yyy . I think we should add an index on mcs_frame_id. FWIW cobra_match has 36M rows and takes 4G of space. Only 2.8s now, but will clearly grow.

      And I'll bet that a bit of thought will find a few more of these.

        Attachments

          Activity

            People

            • Assignee:
              kiyoto.yabe Kiyoto Yabe
              Reporter:
              cloomis cloomis
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: