# aarondfrancis/fast-paginate

A fast implementation of offset/limit pagination for Laravel.

Repository: https://github.com/aarondfrancis/fast-paginate
Canonical: https://ross.abutalabs.com/products/fast-paginate
Language: PHP
License: MIT
License Family: permissive
Topics: laravel, pagination
Last push: 2025-11-28T04:22:53+00:00

## Health v2 (maintenance only)
Score: 47/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 54, release rhythm 8, longevity 100
- inputs: {"age_days": 1688, "days_push": 278, "days_rel": 554, "gap_med": null, "n_releases_24m": 1}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1371, forks 70 (observed 2026-08-28T04:04:32.072681+00:00)

## What it is
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
- artifact type: library
- maturity: stable
- function: database, orm
- domain: databases, web-development, performance
- platform: php
- tags: laravel, pagination, deferred-join, query-optimization, eloquent

## Member repositories
- aarondfrancis/fast-paginate (main) score 47

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:32.072681+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:40:49.099728+00:00, confidence not recorded.
  - readme: https://github.com/aarondfrancis/fast-paginate (fetched 2026-08-28T04:04:32.072681+00:00, sha b8e2833d4cdd)
- Data as of 2026-08-30T08:39:29.467469+00:00.