[INSTRM-730] Add index on mcsData's frameId column Created: 14/Aug/19 Updated: 06/Sep/19 Resolved: 06/Sep/19 |
|
| Status: | Done |
| Project: | Instrument control development |
| Component/s: | spt_operational_database |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Normal |
| Reporter: | cloomis | Assignee: | Kiyoto Yabe |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| 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. |
| Comments |
| Comment by Kiyoto Yabe [ 22/Aug/19 ] |
|
I made a pull request on this. If this fix is OK, I'll merge the branch. |