Accounts with more than 500 items experience dashboard load times of 8–12 seconds. Query profiling reveals an N+1 issue where vote counts are fetched individually per item rather than in a single aggregated query.
Fix: Eager load vote counts using withCount('votes') and cache the result for 60 seconds.