Dashboard loading slowly for users with many projects

created by Bob Smith at Jan 25, 2026, 08:00 AM

What's Wrong

Several enterprise customers have reported that their dashboard takes 5+ seconds to load. After some investigation, this correlates with the number of projects they have.

Impact

  • Acme Corp (487 projects) - 5.2s load time
  • TechStart Inc (312 projects) - 3.8s load time
  • Regular users (<50 projects) - normal load times

This is becoming a blocker for our enterprise sales.

Possible Causes

  • Standard ORM query without optimization
  • No indexes on projects table beyond primary key
  • No pagination on backend (all projects loaded at once)

Next Steps

  1. Add database-level pagination with LIMIT/OFFSET
  2. Add appropriate indexes
  3. Measure improvement before considering caching

Activity

Bob Smith added label Bug

Jan 25, 2026, 08:05 AM

TU
Test UserJan 25, 2026, 10:30 AM

I profiled the dashboard endpoint. The issue is we're fetching ALL projects upfront, even though we only show 10 per page. ``` GET /api/dashboard - DB query: 2.3s (fetching 500+ projects) - Serialization: 0.8s - Total: 3.1s ``` We need pagination at the database level, not just UI level.

AJ
Alice JohnsonJan 25, 2026, 11:00 AM

Ouch, that's bad. Should be an easy fix though - just need to add LIMIT/OFFSET to the query and update the API to accept page params.