[Koha-bugs] [Bug 18821] TrackLastPatronActivity is a performance killer

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Mar 23 14:12:17 CET 2018


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

Kyle M Hall <kyle at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #65687|0                           |1
        is obsolete|                            |

--- Comment #6 from Kyle M Hall <kyle at bywatersolutions.com> ---
Created attachment 73175
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=73175&action=edit
Bug 18821 - TrackLastPatronActivity is a performance killer

Enabling TrackLastPatronActivity can cause an extreme performance hit,
especially on the staff side during checkin and checkout. It makes more sense
to only update the last activity timestamp on the first access of a given
session. This will greatly improve performance while retaining the same basic
information.

Test Plan:
1) Apply this patch
2) Start a new session ( a private browser window works well )
3) Note the lastseen column in the borrowers table is updated
4) Browse a few pages, not the lastseen column is not updated again
5) Close the browser window and repeat steps 2-4
6) prove t/db_dependent/Members.t

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list