Optimize slow Laravel pages - N+1 queries and 22s load times
Project Deliverables & Description
The main dashboard in our Laravel app now takes about 22 seconds to load because of data growth (around 6 million rows in the biggest table). Debugbar shows hundreds of queries per request and no indexes on the filters we use. I would like the slowest endpoints profiled, N+1 problems fixed with eager loading, the right indexes added through migrations, and caching where it is safe.
Task requirements:
- Relevant experience with Laravel, PHP, MySQL, Query Optimization, Eloquent
- Expected result: Dashboard loads in under 2 seconds with the same data, query count reduced and documented, and migrations that can be rolled back.
- Target completion: ~3 days
Available to award quickly to someone who can deliver cleanly. Thanks!
Required Skills & Technologies
Contract Parameters
Budget Setup
$60 - $100
fixed Rate Structure
Experience Level
Intermediate
Target expertise level requested
Project Scope
Intermediate
Target project delivery scope
Contract Identifier: fae50e51
Professional Trust Score
Client holds verified capital secured in project escrow holds.
Client Identity Verified
Corporate background confirmed
Escrow Lock Enforcement
Secure milestone hold verified
BotDigit Arbitrated
Arbitration protection active