open-ils.auth.authenticate.init should not retrieve patron by id::numeric
Bug #1745486 reported by
Galen Charlton
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned | ||
2.12 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
open-ils.
SELECT * FROM actor.usr WHERE id = 123.00000;
When faced with this, PostgreSQL ends up doing a sequential scan on the actor.usr table rather than an index scan. While in practice this isn't quite as bad as it might seem, it's still two orders of magnitude slower than "SELECT * FROM actor.usr WHERE id = 123" and imposes unnecessary I/O load on the database that can add up a bit for a large, heavily used system.
Evergreen 2.0
Changed in evergreen: | |
assignee: | nobody → Bill Erickson (berick) |
status: | New → Confirmed |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
More specifically, it does this when the barcode is passed to open-ils. auth.authentica te.init rather than the username.