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.

Sign up for GitHub

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

Jump to bottom

Load geometries more efficiently #2037

Open

svamaa opened this issue Aug 27, 2024 · 1 comment · May be fixed by #2045

Assignees

Labels

Collaborator

svamaa commented Aug 27, 2024

Now, there are 3 db requests to intersect the real estate with the plr.

voisardf added the usergroup work label

Collaborator

michmuel commented Aug 27, 2024 •

edited

Loading

There are repeated queries on geometry in the standard, oereblex and interlis sources.

standard
https://github.com/openoereb/pyramid_oereb/blob/ec86cb5af4671edd850d5a26c37b5c71dc03ad3b/pyramid_oereb/contrib/data_sources/standard/sources/plr.py#L664C1-L666C22
https://github.com/openoereb/pyramid_oereb/blob/ec86cb5af4671edd850d5a26c37b5c71dc03ad3b/pyramid_oereb/contrib/data_sources/standard/sources/plr.py#L685C1-L690C88

oereblex
[inherited from standard source]

interlis
https://github.com/openoereb/pyramid_oereb/blob/ec86cb5af4671edd850d5a26c37b5c71dc03ad3b/pyramid_oereb/contrib/data_sources/interlis_2_3/sources/plr.py#L528C1-L530C22
https://github.com/openoereb/pyramid_oereb/blob/ec86cb5af4671edd850d5a26c37b5c71dc03ad3b/pyramid_oereb/contrib/data_sources/interlis_2_3/sources/plr.py#L548C1-L553C88

Purpose of this issue: analysis if/how these repeated queries can be simplified.

michmuel self-assigned this

michmuel linked a pull request

that will close this issue

reduce-number-of-spatial-queries #2045

Draft

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment