UI generates search for middle name without supporting index

Description

In , search by middle name was implemented, but it appears no corresponding database index was created in mod-users to support it. This causes a significant performance problem with a user count of 360,000.

Creating these indexes:

…resolves the issue (so we have a workaround, but it would be nice to have this fixed in the mainline code).

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

Activity

Show:
Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Volaris

Fix versions

Release

Ramsons (R2 2024)

RCA Group

Implementation coding issue

Affected releases

Poppy (R2 2023)

Affected Institution

Spokane Public Libraries

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created April 18, 2024 at 7:52 PM
Updated October 30, 2024 at 7:07 AM
Resolved May 2, 2024 at 11:46 AM
TestRail: Cases
TestRail: Runs