Bug 33930 - Single record can have too many items for performance
Summary: Single record can have too many items for performance
Status: RESOLVED DUPLICATE of bug 33568
Alias: None
Product: Koha
Classification: Unclassified
Component: Cataloging (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-06 19:34 UTC by Lisette Scheer
Modified: 2024-05-20 15:55 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 ***