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/5...@github.com>
_______________________________________________ rails-dev mailing list rails-dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/rails-dev
