[openstreetmap/openstreetmap-website] Add order parameter to changeset query API call (PR #4158)

[Anton Khorev]

Example of slow request

`https://api.openstreetmap.org/api/0.6/changesets.json?limit=10&time=20200501T000000Z&order=oldest`

It probably goes through almost the entire created_at index because there's no condition created_at. The lower bound is checked only on closed_at. In the fix I added a condition that skips changesets that are definitely too old to be open at the lower bound (2 * max age).

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

Message ID: <openstreetmap/openstreetmap-website/pull/4158/c1676417839 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20230813/4ff5f34c/attachment.htm>