[MODFQMMGR-45] Query builder - Slow performance of test queries executed against Items entity type Created: 12/Oct/23 Updated: 23/Oct/23 Resolved: 23/Oct/23 |
|
| Status: | Closed |
| Project: | mod-fqm-manager |
| Components: | None |
| Affects versions: | None |
| Fix versions: | 1.0.0 |
| Type: | Story | Priority: | P2 |
| Reporter: | Punnoose Kutty Jacob Pullolickal | Assignee: | Matt Weaver |
| Resolution: | Done | Votes: | 0 |
| Labels: | back-end | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Sprint: | Corsair Sprint 176 |
| Story Points: | 2 |
| Development Team: | Corsair |
| Release: | Poppy (R2 2023) |
| RCA Group: | Implementation coding issue |
| Description |
|
Purpose/Overview: Purpose of this story is to fix slow performance of queries executed against "Items" entity type.
Examples of slow queries:
Proposed solution: Create a smaller view that just join "item", "holdingrecords" and "instance" tables.
|
| Comments |
| Comment by Matt Weaver [ 18/Oct/23 ] |
|
With the smaller view, we get faster results in some cases. Note: because we convert text fields to lower case when doing text operators, we can't take full advantage of the indexes involved yet, but that will requite some extra work that is out of scope of this ticket |