Hopeless holds interface could benefit from an index
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned | ||
3.9 |
Fix Released
|
Medium
|
Unassigned |
Bug Description
The hopeless holds interface runs the "wide holds" query limited to holds whose "hopeless" date is in a user-specified range.
The query to fetch hopeless holds currently can be slow on large databases as there is currently no index on action.
Empirical testing suggests that adding the index can decrease the query time from 3-5 seconds to less than a second, thereby making the interface more responsive. Furthermore, there is reason to believe that a fetch of all hopeless holds in a large consortium could occasionally use query plans that are so bad that many gigabytes of PostgreSQL temp files are created.
tags: | added: circ-holds performance |
Changed in evergreen: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
Changed in evergreen: | |
milestone: | none → 3.9.1 |
assignee: | nobody → Jason Stephenson (jstephenson) |
Changed in evergreen: | |
assignee: | nobody → Evergreen Bug Maintenance (bugmaster) |
assignee: | Evergreen Bug Maintenance (bugmaster) → nobody |
Changed in evergreen: | |
milestone: | 3.9.1 → none |
no longer affects: | evergreen/3.8 |
no longer affects: | evergreen/3.7 |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
I've pushed a branch that adds the index: user/dyrcona/ lp1972738- add-index
https:/ /git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ dyrcona/ lp1972738- add-index