[openstreetmap/openstreetmap-website] Add order parameter to changeset query API call (PR #4158)
Anton Khorev
notifications at github.com
Sun Aug 13 16:30:41 UTC 2023
Looks like there are performance problems now. When the query is limited by a user, it runs ok. When it asks for every changeset in a specified time window, it's slow. Apparently the db doesn't like `WHERE (... and created_at <= $sometime) ORDER BY created_at ASC` with the where condition and the order going in different directions.
--
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/4158#issuecomment-1676405939
You are receiving this because you are subscribed to this thread.
Message ID: <openstreetmap/openstreetmap-website/pull/4158/c1676405939 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20230813/ca4526df/attachment.htm>
More information about the rails-dev
mailing list