Bug 33930

Summary: Single record can have too many items for performance
Product: Koha Reporter: Lisette Scheer <lisette>
Component: CatalogingAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: m.de.rooy
Version: unspecified   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Lisette Scheer 2023-06-06 19:34:31 UTC
If a library has a lot of items (1000+) on a single record, such as all of National Geographic on the same record, it will cause slowdowns in the system. 
Specifically can make (at least) the following things difficult:

-searching
-loading records
-holds


Having a limit would be helpful.
Comment 1 Katrin Fischer 2023-06-08 08:05:46 UTC
Introducing a limit seems not the ideal solution, and a reasonable limit might be different depending on your system's resources and setup. I like the work on the item table that seems one way to make this work better and is waiting for testing: bug 33945, 33568
Comment 2 Lisette Scheer 2023-06-08 14:25:47 UTC
(In reply to Katrin Fischer from comment #1)
> Introducing a limit seems not the ideal solution, and a reasonable limit
> might be different depending on your system's resources and setup. I like
> the work on the item table that seems one way to make this work better and
> is waiting for testing: bug 33945, 33568

Katrin, 
I think you're correct that those bugs should fix this issue. 
Thanks!
Lisette
Comment 3 Lisette Scheer 2024-05-20 15:55:02 UTC
Both of the other bugs have been fixed. I'm going to close this one

*** This bug has been marked as a duplicate of bug 33568 ***