mroderick / codebar-planner

96%

master: 95%

LAST BUILD ON BRANCH fix/dashboard-eager-loading

branch: fix/dashboard-eager-loading

CHANGE BRANCH

x

Reset

Sync Branches

• fix/dashboard-eager-loading
• add-docs
• add-editor-config
• add-scout-apm
• add-sitemap-generator
• add-tests-for-2515
• attempt-to-fix-issue-template
• bundle-ignore-junk
• docs/improve-workflow-documentation
• feature/chapters-sidebar-v3
• feature/chapters-sidebar-viewcomponent
• feature/events-upcoming-past
• feature/homepage-events-limit
• feature/seeds-performance-data
• fix-broken-chosen
• fix-duplicate-waiting-list-entries
• fix-error-656-undefined-method-event-for-nil
• fix-member-details-validation-order
• fix-missing-authentication-error-translation
• fix/cookie-serializer-migration
• fix/event-description-xss-vulnerability
• fix/events-controller-fixes
• fix/events-sponsors-eager-loading
• fix/find-by-nil-errors
• fix/flaky-listable-tests
• fix/homepage-n-plus-one-eager-loading
• fix/homepage-performance
• fix/member-attending-cache
• fix/render-not-found-json-error
• freeze-postgres-version
• imagemagick-check
• improve-intro-text
• improve-language
• improve-og-tags
• improve-repository-configs
• increase-delayed-job-max-runtime
• issue-2367-workshop-feedback
• issue-2445
• link-to-chapters-from-pills
• lock-gem-platforms
• make-event-rendering-faster
• no-og-tags-on-admin
• optimise-images
• params-expect
• policy-tests
• pr/fix-find-by-nil-errors
• remove-2024-impact-report-banner
• remove-bootsnap
• remove-go-squared
• remove-google-analytics
• remove-meta-partial
• remove-puma-cluster-mode-config
• remove-skylight
• remove-twitter
• remove-unused-i18n-features
• remove-unused-new-relic
• replace-claude-md-with-agents-md
• speedup-ci-tests
• stop-pinning-image-processing
• stop-using-update-attribute
• update-year-for-impact-report
• upgrade-ruby
• use-playwright
• use-rails-7-1-defaults
• workshop-invitation-controller

Build # 22314229045

Build Type

push

github

Committed by mroderick

Commit Message

fix: eager load permissions and organisers in DashboardController

Motivation:
Bullet was reporting N+1 queries on the homepage (/). The view accesses
event.organisers which requires the permissions join table to be eager loaded.

Analysis:
- The all_events method loads Event and Workshop objects that need
  organisers and permissions preloaded
- Also fixed Meeting eager loading to include permissions
- Changed from includes() to eager_load() to handle nested through-associations
  (organisers goes through permissions)

Before: N+1 queries per event for organisers
After: Single query with JOIN on permissions table.

Run Details

6 of 6 new or added lines in 1 file covered. (100.0%)

3315 of 3466 relevant lines covered (95.64%)

45.4 hits per line