Back to bug 40936

Who When What Removed Added
kyle 2025-10-02 12:02:06 UTC Assignee koha-bugs kyle
kyle 2025-10-02 12:08:08 UTC Attachment #187259 Attachment is obsolete 0 1
kyle 2025-10-02 12:08:17 UTC Attachment #187260 Attachment is obsolete 0 1
kyle 2025-10-02 12:08:25 UTC Attachment #187261 Attachment is obsolete 0 1
kyle 2025-10-02 12:08:31 UTC Attachment #187262 Attachment is obsolete 0 1
kyle 2025-10-02 12:08:38 UTC Attachment #187263 Attachment is obsolete 0 1
kyle 2025-10-02 12:13:17 UTC Attachment #187258 Attachment is obsolete 0 1
kyle 2025-10-02 12:13:24 UTC Attachment #187265 Attachment is obsolete 0 1
kyle 2025-10-02 12:13:32 UTC Attachment #187266 Attachment is obsolete 0 1
kyle 2025-10-02 12:13:52 UTC Status NEW Needs Signoff
martin.renvoize 2025-10-09 11:00:44 UTC Attachment #187264 Attachment is obsolete 0 1
martin.renvoize 2025-10-09 11:02:17 UTC Text to go in the release notes This change introduces a new database index to improve the performance of patron searches
CC martin.renvoize
Text to go in the release notes , this operation can take a significant amount of time and consume considerable server resources (CPU and I/O).

While modern database systems can often perform this operation without locking the table for the entire duration, especially in large databases. This will prevent slow searches and potential database server issues related to sorting patrons by name and address.

**System Administrator Note:**
Applying this update will add a new index to the `borrowers` table.
Status Needs Signoff Signed Off
Text to go in the release notes , a general slowdown of the system is expected. It is **strongly recommended** to run the upgrade (`updatedatabase.pl`) during a planned maintenance window to avoid impacting users. On systems with a large number of patrons
martin.renvoize 2025-10-09 12:33:17 UTC CC tomascohen

Back to bug 40936