Bug 23503

Summary: Personal name authority search: search results aren't sorted in alphabetical order after page 51
Product: Koha Reporter: Marie-Luce Laflamme <marie-luce.laflamme>
Component: SearchingAssignee: Bugs List <koha-bugs>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: fridolin.somers
Version: Main   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Marie-Luce Laflamme 2019-08-23 18:00:40 UTC
After performing an authority search by "Personal name", we have noticed that search results aren't sorted in alphabetical order after page 51.



1) Go to Authority search (click on "More" and select "Authorities" on the top left corner)
2) Select "Personal Name" in the Default Menu. Leave the search box empty and submit.
3) Assess the first 50 pages of results (all results are sorted alphabetically)
4) Access page 51 and notice the different pattern of results ( results aren’t sorted in alphabetical order).
Comment 1 Katrin Fischer 2019-11-02 11:46:36 UTC
I think this might be related to a setting in Zebra - a limit on how many records are sorted.
Comment 2 Fridolin Somers 2021-04-23 09:07:52 UTC
Indeed, it is a performance limit of Zebra ﷐[U+1F993]﷑ , option "sortmax".

You can see it is defined in biblios config :
https://git.koha-community.org/Koha-community/Koha/src/commit/f096a8dffcb35c153c3f4f27ce5767b1c7fb3f75/etc/zebradb/zebra-biblios-dom.cfg#L53

So for authorities the limit is at default value 1000.
Be careful on performance and temporary disk space impact when increasing this value.

Best regads,