[OBSPROC-42] add index to the version column in fluxstd in targetdb Created: 22/Apr/23 Updated: 01/Jun/23 Resolved: 22/Apr/23 |
|
| Status: | Done |
| Project: | PFS observation processing/procedure |
| Component/s: | ets_target_database |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Normal |
| Reporter: | monodera | Assignee: | monodera |
| Resolution: | Done | Votes: | 0 |
| Labels: | targetDB | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Epic Link: | targetDB | ||||||||
| Description |
|
Since flux standards are queried usually done by specifying Fstar versions, the search will become fast by introducing index to the version column.
|
| Comments |
| Comment by monodera [ 22/Apr/23 ] |
|
Running the following query: SELECT count(*) FROM fluxstd WHERE version='3.0'; Before indexing: Time: 167003.810 ms (02:47.004) Improvement is about x17. |