[openstreetmap/openstreetmap-website] Use subqueries to find nested members more efficiently (PR #5636)

[Tom Hughes]

Use subqueries to do the selection in one go in the database which also avoids to deduplicate in rails.

Also pushes all visibility filtering into the query.
You can view, comment on, or merge this pull request online at:

  https://github.com/openstreetmap/openstreetmap-website/pull/5636

-- Commit Summary --

  * Use subqueries to find nested members more efficiently

-- File Changes --

    M app/controllers/api/nodes/relations_controller.rb (13)
    M app/controllers/api/nodes/ways_controller.rb (8)
    M app/controllers/api/relations/relations_controller.rb (13)
    M app/controllers/api/ways/relations_controller.rb (13)

-- Patch Links --

https://github.com/openstreetmap/openstreetmap-website/pull/5636.patch
https://github.com/openstreetmap/openstreetmap-website/pull/5636.diff

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/5636
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/5636 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250209/3d863ebe/attachment.htm>