[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Martin Renvoize changed: What|Removed |Added Text to go in the|Sponsored and written by| release

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Jonathan Druart changed: What|Removed |Added Blocks||23982 Referenced Bugs:

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Lucas Gass changed: What|Removed |Added Status|Pushed to stable|Pushed to oldstable

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Fridolin SOMERS changed: What|Removed |Added Status|Pushed to master|Pushed to stable

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Martin Renvoize changed: What|Removed |Added CC|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Martin Renvoize changed: What|Removed |Added Status|Passed QA |Pushed to master

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #23 from Martin Renvoize --- Nice work! Pushed to master for 19.11.00 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

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

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Paul Hoffman changed: What|Removed |Added See Also||https://bugs.koha-community

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

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

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

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

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #21 from Tomás Cohen Arazi --- Created attachment 93157 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=93157=edit Bug 23624: (QA follow-up) Test error cases Signed-off-by: Tomas Cohen Arazi -- You

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #20 from Tomás Cohen Arazi --- Created attachment 93156 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=93156=edit Bug 23624: (QA follow-up) Don't fetch the count unless the query was successful

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #19 from Tomás Cohen Arazi --- Created attachment 93155 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=93155=edit Bug 23624: (QA follow-up) Optimize even more This patch makes counting the results

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #18 from Tomás Cohen Arazi --- Created attachment 93154 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=93154=edit Bug 23624: Unit tests Signed-off-by: Tomas Cohen Arazi Signed-off-by: Liz Rea

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Tomás Cohen Arazi changed: What|Removed |Added Attachment #92974|0 |1 is obsolete|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #17 from Tomás Cohen Arazi --- Created attachment 93153 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=93153=edit Bug 23624: Count rows in report without (potentially) consuming all memory

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Tomás Cohen Arazi changed: What|Removed |Added Attachment #92976|0 |1 is obsolete|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Tomás Cohen Arazi changed: What|Removed |Added Attachment #92975|0 |1 is obsolete|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Tomás Cohen Arazi changed: What|Removed |Added Attachment #93037|0 |1 is obsolete|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Tomás Cohen Arazi changed: What|Removed |Added Status|Signed Off |Passed QA -- You are

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #16 from Owen Leonard --- (In reply to Paul Hoffman from comment #15) > Do *I* need to sign off on this? I'm woefully ignorant of Koha community > dev practices. One sign-off is enough to move it forward in the

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #15 from Paul Hoffman --- Do *I* need to sign off on this? I'm woefully ignorant of Koha community dev practices. -- You are receiving this mail because: You are watching all bug changes.

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Liz Rea changed: What|Removed |Added Status|Failed QA |Signed Off -- You are receiving

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Liz Rea changed: What|Removed |Added Attachment #92995|0 |1 is obsolete|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #13 from Kyle M Hall --- Created attachment 92995 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=92995=edit Bug 23624: (QA follow-up) Don't fetch the count unless the query was successful -- You are

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

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

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Liz Rea changed: What|Removed |Added Attachment #92970|0 |1 is obsolete|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Liz Rea changed: What|Removed |Added Attachment #92969|0 |1 is obsolete|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Liz Rea changed: What|Removed |Added Attachment #92968|0 |1 is obsolete|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Joy Nelson changed: What|Removed |Added Text to go in the||Sponsored and written by

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #8 from Paul Hoffman --- Thanks, that's the perfect solution. I had contemplated (and rejected) munging the SQL to get a count but never thought of using a subquery. -- You are receiving this mail because: You are

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #7 from Tomás Cohen Arazi --- Created attachment 92970 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=92970=edit Bug 23624: (QA follow-up) Optimize even more This patch makes counting the results have

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #6 from Tomás Cohen Arazi --- Created attachment 92969 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=92969=edit Bug 23624: Unit tests Signed-off-by: Tomas Cohen Arazi -- You are receiving this

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #5 from Tomás Cohen Arazi --- Created attachment 92968 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=92968=edit Bug 23624: Count rows in report without (potentially) consuming all memory

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Tomás Cohen Arazi changed: What|Removed |Added Attachment #92903|0 |1 is obsolete|

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Tomás Cohen Arazi changed: What|Removed |Added Status|Signed Off |Passed QA -- You are

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Tomás Cohen Arazi changed: What|Removed |Added Assignee|koha-b...@lists.koha-commun |p...@flo.org

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #4 from Paul Hoffman --- It could be, but the number seems more like an implementation detail than a preference or config option. And it seems reasonable -- a million rows, which without this patch would probably kill

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #3 from Kyle M Hall --- QA thoughts: 1000 per fetch feels arbitrary. Should that number be controllable via a config entry or syspref? -- You are receiving this mail because: You are the assignee for the bug. You are

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

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

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

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

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Kyle M Hall changed: What|Removed |Added Severity|major |normal

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 --- Comment #1 from Paul Hoffman --- I've changed the priority and severity on this bug report, along with #23626, to P2/major since the problem they solve can make Koha unusable. -- You are receiving this mail because: You are

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Paul Hoffman changed: What|Removed |Added Severity|normal |major -- You are receiving

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Paul Hoffman changed: What|Removed |Added Priority|P5 - low|P2 -- You are receiving

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Paul Hoffman changed: What|Removed |Added See Also||https://bugs.koha-community

[Koha-bugs] [Bug 23624] Count rows in report without (potentially) consuming all memory

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Paul Hoffman changed: What|Removed |Added Blocks||23626 Referenced Bugs: