benwbrum / fromthepage / 26294998176

70%

push

github

Use DB-level UNION for nightly user activity and add batched processing (#5537)

* Optimize nightly user activity selection with SQL union

* Replace ENV batch size with NIGHTLY_USER_ACTIVITY_BATCH_SIZE constant

Agent-Logs-Url: https://github.com/benwbrum/fromthepage/sessions/7da27767-dd33-43ca-9283-f8d08f3814b7

Co-authored-by: benwbrum <199961+benwbrum@users.noreply.github.com>

* Preload notification association within each batch to avoid N+1 queries

Agent-Logs-Url: https://github.com/benwbrum/fromthepage/sessions/3045d17c-aeef-4cce-9c63-bf7bb04bcbc5

Co-authored-by: benwbrum <199961+benwbrum@users.noreply.github.com>

---------

Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>
Co-authored-by: benwbrum <199961+benwbrum@users.noreply.github.com>

2445 of 4015 branches covered (60.9%)

Branch coverage included in aggregate %.

10027 of 13809 relevant lines covered (72.61%)

159.19 hits per line