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 Priority P5 - low P3
Assignee koha-bugs nick
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 #113425 Attachment is obsolete 0 1
Attachment #113424 Attachment is obsolete 0 1
nick 2020-11-11 02:40:54 UTC Attachment #113452 Attachment is obsolete 0 1
Attachment #113451 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 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 Text to go in the release notes , to delay as much as possible the DB access, and thus allowing for further filtering on the callers, through chaining.
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
Summary Koha::Item::pickup_locations is very inefficient, causing timeouts on records with large numbers of holds/items Improve Koha::Item::pickup_locations performance
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 2020-11-13 13:24:18 UTC Status Passed QA Pushed to master
Version(s) released in 20.11.00
lucas 2020-11-16 22:53:23 UTC CC lucas
lucas 2020-11-17 15:30:16 UTC Status Pushed to master Pushed to stable
Version(s) released in 20.11.00 20.11.00, 20.05.06
aleisha 2020-11-17 20:24:18 UTC Resolution --- FIXED
CC aleisha
Status Pushed to stable RESOLVED
jonathan.druart 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