Change #3843
| Category | None |
| Changed by | Chris Sharp <csharp@georgialibraries.org> |
| Changed at | Tue 14 Feb 2017 09:14:40 |
| Repository | git://git.evergreen-ils.org/Evergreen.git |
| Project | Evergreen |
| Branch | master |
| Revision | b09af142effa37097984f327b59a629c7b1dd930 |
Comments
LP#1643932 - Fix search slowness when patron searching by username Bug 1501781 introduced a feature to improve patron name searching, but which was causing very slow queries when searching by username. Adding an index to username solves the slowness problem. Suggested by Mike Rylander. Signed-off-by: Chris Sharp <csharp@georgialibraries.org> Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Changed files
- Open-ILS/src/sql/Pg/005.schema.actors.sql
- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor_usr_usrname_unaccent_idx.sql