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 , 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 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
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 QA Contact testopia nick
Patch complexity --- Trivial patch
CC lucas
lucas 2025-10-16 21:21:56 UTC Version(s) released in 25.11.00
Status Passed QA Pushed to main
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 CC fridolin.somers
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
wainuiwitikapark 2026-02-27 00:11:09 UTC Status Pushed to oldstable Needs documenting

Back to bug 40936