aarondfrancis/fast-paginate

Health v2 · maintenance only

Adoption not part of the score

1371 stars · 70 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A Laravel package providing a drop-in fastPaginate() macro that speeds up offset/limit pagination using a deferred-join-style subquery technique. It fetches only IDs in the paginated subquery before retrieving full rows, minimizing data examined by the database.

Use cases

• paginate large Laravel tables quickly
• speed up deep offset pagination on MySQL
• replace paginate() with a faster drop-in
• paginate Eloquent relationships efficiently
• reduce database load for paginated list pages

When to choose

• you use Laravel and standard paginate() is slow on large datasets
• you need deep-page offset pagination performance without switching to cursor pagination
• you want a drop-in replacement with the same API

When to avoid

• you're not using Laravel or Eloquent
• you need cursor/keyset pagination semantics
• your dataset is small enough that default pagination is fine

Facets

library · maturity stable

database orm databases web-development performance php laravel pagination deferred-join query-optimization eloquent

Member repositories

For agents

markdown · JSON · MCP: product_card(name="aarondfrancis/fast-paginate")