Cache unread-notifications count (5.1% DB time, 41k calls): SELECT count(*) FROM notifications WHERE userId AND readAt IS NULL fires every page load — counter column on users or 30s sessionStorage TTL. See db/pg-stat-statements-report.md

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-09
• wi-cli-venus parentChanged · 2026-06-09
  parent=#819
• wi-cli-venus completed · 2026-06-14
  perf(notifications): replaced per-page COUNT(*) (5.1% DB time, 41k calls) with users.unreadNotificationsCount counter column + triggers. Shipped 94be779 v2.16.45, audit PASS, live-version confirmed.