Bug 14932 - serials/serials-collection.pl-page is very slow. GetFullSubscription...
authorOlli-Antti Kivilahti <olli-antti.kivilahti@jns.fi>
Thu, 1 Oct 2015 12:23:23 +0000 (15:23 +0300)
committerKyle M Hall <kyle@bywatersolutions.com>
Thu, 13 Apr 2017 12:31:47 +0000 (08:31 -0400)
commit6940aa91a53371ba49528022954a9a349044ab63
tree3913d96f58ab1c5fe7de2823d4d19ed6dbf21341
parenta6c26f009536e831461c1e91f8bafe07ca75d283
Bug 14932 - serials/serials-collection.pl-page is very slow. GetFullSubscription* checks permission for each serial!

Currently we have subscriptions with 300+ serials received.
It takes a lot of time to show serials-collection.pl (~20s).
This is especially troublesome when receiving serials, since after receival we get redirected to that page.

We no longer can receive daily serials in the allotted timeframe.

This quick and dirty fix prevents checking the subscription editing for each serial, but instead checks it for the first serial only.

This reduced page load time by ~18s

TEST PLAN:
1. Receive ~300 serials (or just a bunch :)  )
2. Observe the gradual slowing of the receival action.

AFTER THIS PATCH:
1. Receive ~300 serials more (or just a bunch)
2. Observe a significant performance improvement.

Signed-off-by: Paul POULAIN <paul.poulain@biblibre.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
C4/Serials.pm