[Koha-bugs] [Bug 29454] Stash branches and itemtypes in plugin objects to reduce DB calls

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

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

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at davidnind.com

--- Comment #3 from David Nind <david at davidnind.com> ---
Testing notes using koha-testing-docker.

I found that for the detail page for the record in the staff interface that the
load time with 1,001 items was significantly improved.

On the edit items page I didn't notice much, if any, improvement.

After the patch was applied I did a flush_memcached and restart_all, but not
fater changing the item type and library names.

Curious as to why we don't use pagination when the there are lots of items, on
the dipslay item page in the staff interface and OPAC.

Some numbers (a bit variable, but generally around the same) - YMMV:

Before patch applied
~~~~~~~~~~~~~~~~~~~~

Item page in the staff interface:

  1027 requests
  6.74 MB / 49.24 KB transferred
  Finish: 20.45 s
  DOMContentLoaded: 18.52 s
  load: 20.01 s

Edit items:

  25 requests
  5.50 MB / 82.78 KB transferred
  Finish: 1.10 min
  DOMContentLoaded: 1.10 min
  load: 1.12 min

After the patch applied
~~~~~~~~~~~~~~~~~~~~~~~

Item page:

  1030 requests
  7.19 MB / 970.08 KB transferred
  Finish: 17.07 s
  DOMContentLoaded: 14.66 s
  load: 16.11 s

Edit items page:

  27 requests
  5.63 MB / 107.81 KB transferred
  Finish: 56.97 s
  DOMContentLoaded: 56.77 s
  load: 58.19 s

After the patch applied and change to item type and library names
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Used the refresh button.

Item page:

  1027 requests
  7.21 MB / 48.92 KB transferred
  Finish: 17.27 s
  DOMContentLoaded: 15.27 s
  load: 16.87 s

Edit items:

  36 requests
  6.40 MB / 1.24 MB transferred
  Finish: 1.10 min
  DOMContentLoaded: 1.09 min
  load: 1.12 min

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