[openstreetmap/openstreetmap-website] Add indes on user+id to changeset and diary comments (PR #5531)

[Tom Hughes]

This adds indexes on `user+id` to diary and changeset comments to make comment views more efficient.

Once this is merged we can switch the `diary_comments` association on users to sort by id instead of creation date and then drop the creation date indexes.
You can view, comment on, or merge this pull request online at:

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

-- Commit Summary --

  * Add indes on user+id to changeset and diary comments

-- File Changes --

    A db/migrate/20250121191749_add_user_comment_indexes.rb (8)
    M db/structure.sql (15)

-- Patch Links --

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

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

Message ID: <openstreetmap/openstreetmap-website/pull/5531 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250121/4f798d9f/attachment-0001.htm>