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 On systems with a large number of patrons 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.
martin.renvoize 2025-10-09 12:33:17 UTC CC tomascohen
nick 2025-10-16 18:13:41 UTC Status Signed Off Passed QA
nick 2025-10-16 18:13:43 UTC Attachment #187650 Attachment is obsolete 0 1
lucas 2025-10-16 20:07:54 UTC CC lucas
QA Contact testopia nick
Patch complexity --- Trivial patch
lucas 2025-10-16 21:21:56 UTC Status Passed QA Pushed to main
Version(s) released in 25.11.00
paul.derscheid 2025-10-29 09:10:07 UTC Version(s) released in 25.11.00 25.11.00,25.05.05
Status Pushed to main Pushed to stable
fridolin.somers 2025-11-10 14:38:31 UTC Status Pushed to stable Pushed to oldstable
Version(s) released in 25.11.00,25.05.05 25.11.00,25.05.05,24.11.11
CC fridolin.somers

Back to bug 40936