Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Poor speed with many records and sorting #104

Open
ollehints opened this issue Nov 2, 2020 · 1 comment
Open

Poor speed with many records and sorting #104

ollehints opened this issue Nov 2, 2020 · 1 comment
Assignees
Labels
bug Something isn't working question Further information is requested
Milestone

Comments

@ollehints
Copy link
Member

If browsing 1 M records, solr is very fast in showing the first pages, but slows considerably in the end of records. Compare:

http://geocase.geocollections.info/api/?start=10&rows=10&sort=fullscientificname%20asc&defType=edismax&q=* 
http://geocase.geocollections.info/api/?start=100000&rows=10&sort=fullscientificname%20asc&defType=edismax&q=* 

This seems to be related to sorting. Maybe the problem appeared after changing the field from string to text?

@ollehints ollehints added the question Further information is requested label Nov 2, 2020
@enmust
Copy link
Member

enmust commented Nov 4, 2020

Tested and it even gets worse if rows is 25 or higher. For some cases the time was almost 10 seconds.
It does indeed get slower in the end of records even when sorting by other fields but fullscientificname seems to be extra slow.

@falkogloeckler falkogloeckler added this to the MVP 2 milestone Dec 10, 2020
@enmust enmust added the bug Something isn't working label Jan 25, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working question Further information is requested
Projects
None yet
Development

No branches or pull requests

3 participants