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

Subclass/Superclass facet-query improvements #255

Open
ThomasThelen opened this issue May 2, 2022 · 0 comments
Open

Subclass/Superclass facet-query improvements #255

ThomasThelen opened this issue May 2, 2022 · 0 comments
Labels
enhancement New feature or request low priority query optimization improving sparql query to have better performance
Milestone

Comments

@ThomasThelen
Copy link
Member

@zilongliu-geo noted that one optimization we can make is by querying for the top-level class when all subclasses are selected. In 1.2.1, when users select the superclass of a facet (typically in a check-box type facet like Hazards)-all of the subclasses are expanded out and placed in the query.

For example, if you select the Fire facet-all of the children are placed in the query using VALUES while we could just use the Fire class. Some basic query testing shows that in this case, searching for the Fire superclass is ~1 second faster than a search using all its subclasses.

@ThomasThelen ThomasThelen added this to the 2.0.0 milestone May 2, 2022
@ThomasThelen ThomasThelen added the enhancement New feature or request label May 2, 2022
@ThomasThelen ThomasThelen modified the milestones: 2.0.0, 2.0.1 Dec 3, 2022
@ThomasThelen ThomasThelen modified the milestones: 2.0.1, 2.0.2 Jun 5, 2023
@ThomasThelen ThomasThelen added query optimization improving sparql query to have better performance low priority labels Jun 5, 2023
@ThomasThelen ThomasThelen modified the milestones: 2.0.2, 2.0.3 Jun 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request low priority query optimization improving sparql query to have better performance
Projects
None yet
Development

No branches or pull requests

1 participant