### Description This PR adds database indexes to improve query performance for the user activity feature as part of #5298. Specifically, it adds concurrent indexes on:
- `gpx_files` table: `[user_id, timestamp]` index to optimize retrieval of user's GPS trace uploads - `notes` table: `[user_id, created_at]` index to optimize retrieval of user's note activities These indexes will support efficient querying of user activities without table scans, improving performance for the activity feed implementation. ### How has this been tested? Testing was performed by: 1. Running the migrations locally to verify successful index creation 2. Checking the database schema to confirm indexes are present You can view, comment on, or merge this pull request online at: https://github.com/openstreetmap/openstreetmap-website/pull/5747 -- Commit Summary -- * Add index on gpx_files.user_id and timestamp * Add index on notes.user_id and created_at -- File Changes -- A db/migrate/20250304172700_add_gpx_files_user_id_timestamp_index.rb (7) A db/migrate/20250304172701_add_notes_user_id_created_at_index.rb (7) -- Patch Links -- https://github.com/openstreetmap/openstreetmap-website/pull/5747.patch https://github.com/openstreetmap/openstreetmap-website/pull/5747.diff -- Reply to this email directly or view it on GitHub: https://github.com/openstreetmap/openstreetmap-website/pull/5747 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
