https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40936 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@openfifth.c | |o.uk Status|Needs Signoff |Signed Off Text to go in the| |This change introduces a release notes| |new database index to | |improve the performance of | |patron searches, 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. On | |systems with a large number | |of patrons, 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, 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. -- You are receiving this mail because: You are watching all bug changes.