Back to bug 26963

Who When What Removed Added
kyle 2020-11-07 12:24:52 UTC Status NEW Needs Signoff
kyle 2020-11-07 12:45:35 UTC Attachment #113282 Attachment is obsolete 0 1
fridolin.somers 2020-11-09 07:34:40 UTC CC fridolin.somers
nick 2020-11-09 16:57:33 UTC Attachment #113329 Attachment is obsolete 0 1
nick 2020-11-09 19:29:48 UTC Attachment #113330 Attachment is obsolete 0 1
nick 2020-11-10 10:54:43 UTC Attachment #113333 Attachment is obsolete 0 1
nick 2020-11-10 11:44:57 UTC CC nick
Attachment #113283 Attachment is obsolete 0 1
nick 2020-11-10 11:45:12 UTC Comment 4 Tag obsolete
nick 2020-11-10 11:45:16 UTC Comment 5 Tag obsolete
nick 2020-11-10 11:45:21 UTC Comment 6 Tag obsolete
nick 2020-11-10 13:38:37 UTC Assignee koha-bugs nick
Priority P5 - low P3
nick 2020-11-10 13:39:09 UTC Blocks 26988
andrew 2020-11-10 16:54:48 UTC Status Needs Signoff Signed Off
andrew 2020-11-10 16:54:51 UTC Attachment #113339 Attachment is obsolete 0 1
andrew 2020-11-10 16:54:54 UTC Attachment #113340 Attachment is obsolete 0 1
martin.renvoize 2020-11-10 17:16:34 UTC Attachment #113419 Attachment is obsolete 0 1
martin.renvoize 2020-11-10 17:16:38 UTC Attachment #113420 Attachment is obsolete 0 1
andrew 2020-11-10 17:17:00 UTC Attachment #113422 Attachment is obsolete 0 1
martin.renvoize 2020-11-10 17:20:37 UTC CC martin.renvoize
martin.renvoize 2020-11-10 17:21:12 UTC Attachment #113423 Attachment is obsolete 0 1
aspencatteam 2020-11-10 17:54:42 UTC CC aspencatteam
nick 2020-11-11 02:32:33 UTC Attachment #113424 Attachment is obsolete 0 1
Attachment #113425 Attachment is obsolete 0 1
nick 2020-11-11 02:40:54 UTC Attachment #113451 Attachment is obsolete 0 1
Attachment #113452 Attachment is obsolete 0 1
nick 2020-11-11 02:46:35 UTC See Also https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26988
Blocks 26988
jonathan.druart+koha 2020-11-11 09:44:05 UTC CC jonathan.druart
Depends on 22284
martin.renvoize 2020-11-11 11:25:44 UTC Summary Koha::Template::Plugin::Branches::pickup_locations is very inefficient, causing timeouts on records with large numbers of holds/items Koha::Item::pickup_locations is very inefficient, causing timeouts on records with large numbers of holds/items
martin.renvoize 2020-11-11 15:52:41 UTC Attachment #113453 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 15:52:44 UTC Attachment #113454 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 15:52:47 UTC Attachment #113455 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 15:52:51 UTC Attachment #113480 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 15:52:54 UTC Attachment #113481 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 15:52:58 UTC Attachment #113483 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 15:53:04 UTC Attachment #113498 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:04:29 UTC Attachment #113511 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:07:47 UTC Attachment #113503 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:07:50 UTC Attachment #113504 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:07:54 UTC Attachment #113505 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:08:32 UTC Attachment #113506 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:08:41 UTC Attachment #113507 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:08:49 UTC Attachment #113508 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:08:58 UTC Attachment #113509 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:09:07 UTC Attachment #113510 Attachment is obsolete 0 1
martin.renvoize 2020-11-11 16:09:16 UTC Attachment #113512 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:23:48 UTC Status Signed Off Passed QA
CC tomascohen
tomascohen 2020-11-11 18:23:54 UTC Attachment #113513 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:24:00 UTC Attachment #113514 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:24:09 UTC Attachment #113515 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:24:17 UTC Attachment #113516 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:24:22 UTC Attachment #113517 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:24:28 UTC Attachment #113518 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:24:32 UTC Attachment #113519 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:24:40 UTC Attachment #113520 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:24:48 UTC Attachment #113521 Attachment is obsolete 0 1
tomascohen 2020-11-11 18:31:11 UTC Summary Koha::Item::pickup_locations is very inefficient, causing timeouts on records with large numbers of holds/items Improve Koha::Item::pickup_locations performance
QA Contact testopia tomascohen
Text to go in the release notes Koha::Item::pickup_locations is very inefficient, causing timeouts on records with large numbers of holds/items.

This development refactors the underlying implementation, and also makes the method return a resultset, to delay as much as possible the DB access, and thus allowing for further filtering on the callers, through chaining.
tomascohen 2020-11-11 18:44:14 UTC Blocks 27002
wizzyrea 2020-11-12 15:22:31 UTC CC wizzyrea
nick 2020-11-13 13:12:39 UTC Blocks 26988
jonathan.druart+koha 2020-11-13 13:24:18 UTC Version(s) released in 20.11.00
Status Passed QA Pushed to master
lucas 2020-11-16 22:53:23 UTC CC lucas
lucas 2020-11-17 15:30:16 UTC Version(s) released in 20.11.00 20.11.00, 20.05.06
Status Pushed to master Pushed to stable
aleisha 2020-11-17 20:24:18 UTC Status Pushed to stable RESOLVED
Resolution --- FIXED
CC aleisha
jonathan.druart+koha 2020-11-20 09:31:25 UTC Blocks 27062
katrin.fischer 2021-06-14 21:29:00 UTC Status RESOLVED CLOSED

Back to bug 26963