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

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

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

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

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

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

Enabling GetPatronLastActivity 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.