Optimize slow Laravel pages - N+1 queries and 22s load times

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!

Category: Development & Software

Skills Required: LaravelPHPMySQLQuery OptimizationEloquent

Budget Range: $60 - $100 USD

Experience Level: Intermediate

Related Developer Talent & Ecosystem Links:

Development & Software Posted 11/19/2026 Practice Opportunity • Free Bid

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

Sign In to Submit a Bid

Bidding is restricted to registered freelance users. Sign in to submit details, propose custom payment milestones, and lock funds in escrow.

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

ESCROW FUNDING SECURED$60 LOCKED

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

HomeJobs
Get Started
ExploreSign In