[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #55 from Kyle M Hall --- (In reply to Kyle M Hall from comment #54) > (In reply to Jonathan Druart from comment #53) > > (In reply to Mohd Hafiz Yusoff from comment #52) > > > Upgrade from Koha 23.05 to 23.11 and get this

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Blocks||35687 Depends on|3568

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Depends on||35687 Referenced Bugs: http

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #54 from Kyle M Hall --- (In reply to Jonathan Druart from comment #53) > (In reply to Mohd Hafiz Yusoff from comment #52) > > Upgrade from Koha 23.05 to 23.11 and get this error > > > > Upgrade to 23.06.00.013 [01:38:2

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #53 from Jonathan Druart --- (In reply to Mohd Hafiz Yusoff from comment #52) > Upgrade from Koha 23.05 to 23.11 and get this error > > Upgrade to 23.06.00.013 [01:38:28]: Bug 28966 - Holds queue view too slow > to load

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Mohd Hafiz Yusoff changed: What|Removed |Added CC||mhb...@gmail.com --- Co

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Tomás Cohen Arazi changed: What|Removed |Added Keywords|additional_work_needed | --- Comment #51 from T

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Blocks||34494 Referenced Bugs: http

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Jonathan Druart changed: What|Removed |Added Keywords||additional_work_needed --

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #49 from Tomás Cohen Arazi --- Created attachment 153939 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153939&action=edit Bug 28966: (QA follow-up) tmp_holdsqueue no longer an iterator Signed-off-by:

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Tomás Cohen Arazi changed: What|Removed |Added CC||tomasco...@gmail.com

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #153928|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #46 from Kyle M Hall --- Created attachment 153928 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153928&action=edit Bug 28966: (QA Follow-up) Fix failing unit tests Test Plan: 1) prove t/db_dependent/

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Keywords||additional_work_needed -- Yo

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #45 from Tomás Cohen Arazi --- Pushed to master for 23.11. Nice work everyone, thanks! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Tomás Cohen Arazi changed: What|Removed |Added Status|Passed QA |Pushed to master

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Marcel de Rooy changed: What|Removed |Added Attachment #153878|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Marcel de Rooy changed: What|Removed |Added Attachment #153877|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Marcel de Rooy changed: What|Removed |Added Attachment #153876|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Marcel de Rooy changed: What|Removed |Added Attachment #153875|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Marcel de Rooy changed: What|Removed |Added Status|Signed Off |Passed QA -- You are rece

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #40 from Kyle M Hall --- Created attachment 153878 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153878&action=edit Bug 28966: (QA follow-up) Remove superfluous joins -- You are receiving this mail b

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #39 from Kyle M Hall --- Created attachment 153877 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153877&action=edit Bug 28966: (QA follow-up) Changes for Koha objects Trivial edits. -- You are recei

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #38 from Kyle M Hall --- Created attachment 153876 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153876&action=edit Bug 28966: Prefetch patron data for holds queue viewer Test Plan: 1) Generate the ho

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #151733|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Status|Failed QA |Signed Off -- You are receiv

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #36 from Kyle M Hall --- (In reply to Marcel de Rooy from comment #33) > join => [ > 'borrower', > #'biblio', > #'biblioitem', > #{ > #

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #35 from Marcel de Rooy --- Created attachment 153120 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153120&action=edit Bug 28966: (QA follow-up) Changes for Koha objects Trivial edits. -- You are re

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Marcel de Rooy changed: What|Removed |Added Status|BLOCKED |Failed QA --- Comment #34

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #33 from Marcel de Rooy --- join => [ 'borrower', #'biblio', #'biblioitem', #{ #'item' => { #'item_gr

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #32 from Marcel de Rooy --- (In reply to Kyle M Hall from comment #0) > We have a partner processing thousands of holds per day, per branch. At this > number of holds, the script loads very slow if it manages to load at a

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Marcel de Rooy changed: What|Removed |Added Status|Signed Off |BLOCKED -- You are receiv

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Marcel de Rooy changed: What|Removed |Added QA Contact|testo...@bugs.koha-communit |m.de.r...@rijksmuseum.nl

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Marcel de Rooy changed: What|Removed |Added CC||m.de.r...@rijksmuseum.nl -

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #30 from Owen Leonard --- Created attachment 151734 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151734&action=edit Bug 28966: Prefetch patron data for holds queue viewer Test Plan: 1) Generate the h

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Owen Leonard changed: What|Removed |Added Attachment #143859|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Owen Leonard changed: What|Removed |Added Status|Needs Signoff |Signed Off Patch complexit

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Magnus Enger changed: What|Removed |Added See Also||https://bugs.koha-community

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #28 from Kyle M Hall --- During my testing I noticed the item's biblioitem's size wasn't displaying correctly. This new edition should fix that! -- You are receiving this mail because: You are watching all bug changes.

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #143860|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Status|Failed QA |Needs Signoff --- Comment #26

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Owen Leonard changed: What|Removed |Added Status|Needs Signoff |Failed QA --- Comment #25 fr

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #24 from Andreas Jonsson --- The column "Patron category" on the page /cgi-bin/koha/circ/view_holdsqueue.pl will contain empty parentheses. This patch removes the patron attribute from each item: -for my $item ( @$

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #23 from Kyle M Hall --- (In reply to Andreas Jonsson from comment #22) > This patch breaks the patch for bug 29760 since it removes the patron from > the itemloop. I'm still seeing the patron category displayed in the p

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Andreas Jonsson changed: What|Removed |Added CC||andreas.jons...@kreablo.se

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #21 from Kyle M Hall --- Created attachment 143860 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=143860&action=edit Bug 28966: Prefetch patron data for holds queue viewer Test Plan: 1) Generate the ho

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #143584|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #19 from Kyle M Hall --- Created attachment 143857 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=143857&action=edit Bug 28966: Add Koha::Object(s) for tmp_holdsqueue -- You are receiving this mail be

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Status|Patch doesn't apply |Needs Signoff -- You are rec

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Emmi Takkinen changed: What|Removed |Added Status|Needs Signoff |Patch doesn't apply --- Com

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #143583|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #125377|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Status|Failed QA |Needs Signoff -- You are rec

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Katrin Fischer changed: What|Removed |Added Status|Signed Off |Failed QA --- Comment #15

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #14 from Fridolin Somers --- Oupsy : > Indeed we should be go back to direct SQL even if faster. Indeed we should not go back to direct SQL even if faster. -- You are receiving this mail because: You are watching all b

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #13 from Jonathan Druart --- (In reply to Fridolin Somers from comment #12) > (In reply to Jonathan Druart from comment #11) > > This is going backward IMO, why not move to DBIC/Koha::Object instead? > > Indeed we should

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Fridolin Somers changed: What|Removed |Added CC||fridolin.som...@biblibre.c

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Jonathan Druart changed: What|Removed |Added CC||jonathan.druart+koha@gmail

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Bug 28966 depends on bug 29015, which changed state. Bug 29015 Summary: Add option to limit Holds Queue report by shelving location / collection https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29015 What|Rem

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #10 from Joonas Kylmälä --- (In reply to Joonas Kylmälä from comment #8) > hmm, this disables the hide_patron_infos_if_needed variable which is > probably not wanted, though the feature is quite broken anyways but this >

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #124854|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Depends on||29015 Referenced Bugs: http

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Joonas Kylmälä changed: What|Removed |Added CC||joonas.kylm...@iki.fi ---

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Emmi Takkinen changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are rece

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Emmi Takkinen changed: What|Removed |Added Attachment #124652|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 David Cook changed: What|Removed |Added CC||dc...@prosentient.com.au -- Y

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Blocks||28974 Referenced Bugs: http

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added See Also||https://bugs.koha-community

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #124639|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Assignee|koha-b...@lists.koha-commun |k...@bywatersolutions.com

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #124629|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #124628|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #124627|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Attachment #124626|0 |1 is obsolete|

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 --- Comment #1 from Kyle M Hall --- Created attachment 124626 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=124626&action=edit Bug 28966: Prefetch patron data for holds queue viewer We have a partner processing t

[Koha-bugs] [Bug 28966] Holds queue viewer too slow to load for large numbers of holds

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28966 Kyle M Hall changed: What|Removed |Added Status|NEW |Needs Signoff -- You are rec