Freegle / iznik-server-go / 28a85112-70dd-4ae0-9d5e-5e44f6cb1fb8

76%

master: 89%

Pull #41

circleci

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>

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