[Koha-bugs] [Bug 31009] Claims list on serials is too slow with many existing late issues

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31009

Pedro Amorim <pedro.amorim at ptfs-europe.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |pedro.amorim at ptfs-europe.co
                   |                            |m
             Status|Needs Signoff               |Failed QA

--- Comment #7 from Pedro Amorim <pedro.amorim at ptfs-europe.com> ---
Did the following testing:
1) Create a serial attached to a vendor
2) Add late issues to the above serial
3) Ran the following SQL query to add test entries to the serial table
INSERT INTO serial (`biblionumber`,`subscriptionid`, `status`) SELECT
`biblionumber`, `subscriptionid`, `status` FROM serial;
4) Ended up with 448 serial entries, claims.pl does indeed become very slow.
5) Applied patch
6) Upon visiting /cgi-bin/koha/serials/claims.pl, I get the following error:
C4::Serials::GetSuppliersWithLateIssues(): DBI Exception: DBD::mysql::db
selectall_arrayref failed: 'koha_kohadev.aqbooksellers.name' isn't in GROUP BY
at /kohadevbox/koha/serials/claims.pl line 48
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77

My suggestion for this performance issue would be to add pagination to the
table.

-- 
You are receiving this mail because:
You are watching all bug changes.