codebar / planner / 28012425553

95%

master: 95%

Pull #2666

github

perf: paginate combined events with DB-level UNION ALL instead of in-memory sort

Extract fetch_upcoming_events and fetch_past_events into two new methods:
- paginated_events(upcoming:) — builds a UNION ALL across workshops,
  meetings, and events with LIMIT/OFFSET at the database level
- load_events(rows) — fetches only the 20 visible rows with full
  eager loading, preserving UNION sort order

Previously, all past workshops (~1100) were loaded into AR objects and
sorted/paginated in Ruby. Now only the current page's 20 rows ever
leave the database.

Benchmark (first load / cached):
  Past events page: 11.3s → 1.3s
  DB queries count: ~119 → 118 (same — view N+1s unchanged)
  Allocations: 25M → 2.9M (cached)

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

3576 of 3750 relevant lines covered (95.36%)

42.0 hits per line