archiverDbPerf.png
subaru_archiver_q+xfer.png
[INSTRM-1016] improve archiver data selection Created: 19/Jun/20 Updated: 07/Oct/20 Resolved: 07/Oct/20 |
|
| Status: | Done |
| Project: | Instrument control development |
| Component/s: | ics_sps_engineering_Lib_dataQuery |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Normal |
| Reporter: | arnaud.lefur | Assignee: | arnaud.lefur |
| Resolution: | Done | Votes: | 0 |
| Labels: | SPS | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
archiverDbPerf.png
subaru_archiver_q+xfer.png
|
| Story Points: | 2 |
| Description |
|
ics_sps_engineering_Lib_dataQuery queries can be optimized to obtain a significant performance, see screenshot attached. |
| Comments |
| Comment by cloomis [ 09/Sep/20 ] |
|
If the date range query is split from the data query, it all goes much faster, even on dbs with years of data (JHU, say). Screen shot of SQL attached; I'll dig up the underlying code. |