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

[bugzilla-daemon at bugs.koha-community.org]

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

M. Tompsett <mtompset at hotmail.com> changed:

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

--- Comment #10 from M. Tompsett <mtompset at hotmail.com> ---
Created attachment 73891
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=73891&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

Signed-off-by: Mark Tompsett <mtompset at hotmail.com>

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