Freegle / iznik-server-go

76%

master: 89%

LAST BUILD ON BRANCH fix/parallel-db-queries

branch: fix/parallel-db-queries

CHANGE BRANCH

x

Reset

• fix/parallel-db-queries
• feat/giftaid-name-fields
• feature/ai-image-review-microvol
• feature/authority-stats-endpoint
• feature/fundraising-appeal
• feature/migrate-http-endpoints
• feature/social-oauth-login
• feature/v2-abtest-writes
• feature/v2-address-writes
• feature/v2-background-tasks
• feature/v2-batch-handlers
• feature/v2-ce-vol-pending-list
• feature/v2-chatmessage-moderation
• feature/v2-chatmessages-patch-delete
• feature/v2-chatrooms-post
• feature/v2-comment-get
• feature/v2-comment-writes
• feature/v2-communityevent-writes
• feature/v2-dashboard-fix
• feature/v2-donations-put
• feature/v2-group-patch
• feature/v2-image-post
• feature/v2-invitation
• feature/v2-memberships-writes
• feature/v2-message-writes
• feature/v2-messages-markseen
• feature/v2-migration-foundation
• feature/v2-mt-endpoints
• feature/v2-mt-switchovers
• feature/v2-newsfeed-writes
• feature/v2-noticeboard-get-delete
• feature/v2-noticeboard-writes
• feature/v2-remaining-handlers
• feature/v2-session-actions
• feature/v2-story-writes
• feature/v2-user-writes
• feature/v2-volunteering-writes
• fix/allowedits-v1-parity
• fix/chat-feedback-and-search
• fix/deploy-watch-inactive
• fix/discourse-9518-18-correct-case-item-name
• fix/discourse-9518-64-spam-admin-patch-permission
• fix/discourse-9518-64-spam-admin-permission
• fix/discourse-9518-64-spamadmin-permission
• fix/discourse-9518-70-merge-by-email
• fix/discourse-9528-test-volunteering-cleanup
• fix/discourse-9530-1-reject-pending-review-on-delete
• fix/discourse-9533-1-chitchat-scroll-pagination
• fix/discourse-9546-1-location-shows-group-name
• fix/discourse-9547-1-phantom-newsletter-task-count
• fix/discourse-9547-3-phantom-task-count-newsletter
• fix/discourse-9548-1-deadline-extend-clears-expired
• fix/discourse-9548-2-extend-deadline-clears-expired-outcome
• fix/discourse-9553-1-banned-member-rejoin
• fix/discourse-9553-2-ban-member-not-working
• fix/discourse-9553-4-banned-list-union-query
• fix/move-logging-to-background
• fix/sentry-7373135842-isochrone-put-string-minutes
• fix/sentry-7373291926-isochrone-stale-id-404
• fix/sentry-7377071204-engaged-string-id
• fix/submodule-update-race-condition
• fix/tech-debt-cleanup
• fix/tn-settings-link
• fix/v2-code-review-fixes
• master
• netlify
• notification-seen-v2
• test-coverage-go-improvements
• test-orb-ci
• test/unified-go-v2

Build # 28a85112-70dd-4ae0-9d5e-5e44f6cb1fb8

Build Type

Pull #41

circleci

Committed by edwh

Commit Message

perf: Reduce API latency with parallel DB queries and query consolidation

Three optimizations:

1. GetGroup: Run polygon, myrole, and email queries in parallel using
   WaitGroup instead of sequentially (saves 15-30ms when all 3 execute).

2. isModerator (communityevent + volunteering): Replace N+1 sequential
   queries (one per group) with a single JOIN query (saves 10-50ms
   depending on number of groups).

3. PutMessage: Combine membership check + posting status fetch into a
   single query instead of two separate queries to the same table.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Pull Request Pull Request #41: perf: Reduce API latency with parallel DB queries

Coverage Stats

56 of 84 new or added lines in 4 files covered. (66.67%)

19342 of 25342 relevant lines covered (76.32%)

21.15 hits per line