In Item Search, the selector "Display ... entries" above the results can be set to "all". If there are a lot of items, it can generate an error. This "all" should be hidden, or maybe displayed only if there are less than xxx (1000?) items to display.
See also https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40815
If the maximum number of rows are limited, there should be possibility configure it. For example 1000 rows is a bit low number when you are doing batch edits. Background jobs allows you to modify bigger batches that 1000 so it would be unfortunate change if the amount is limited to 1000 by default.
It also works well for more than 1.000 items in most cases. For most our libraries "all" works and can be useful. If a limit is proposed, it should be configurable.
The only correct way to implement this need is to implement a generic solution, in the table settings. We already have "Default display length", we could have a "Max Length", or even a multi select for each table with the different options (10, 20, 50, 100, 500, all). Preferably on top of bug 38259.