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

Add index on mcsData's frameId column

    XMLWordPrintable

    Details

      Description

      Could we get an index on the frameId column of the mcsData table? Nearly all queries will be for all the detections on one frame. I have added an index to the live database and it removes the increasingly significant overhead.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: