https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40936

Martin Renvoize (ashimema) <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]
                   |                            |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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to