made with Laravel

#Utility
icon-eye-dark Created with Sketch. 2.035

Fast Paginate for Laravel

Offset/limit Pagination Implementation

Visit Site

Description

Offset/limit Pagination Implementation

"Fast Paginate offers a fast limit/offset pagination macro for Laravel. It can be used in place of the standard paginate methods.

This packages uses a SQL method similar to a "deferred join" to achieve this speedup. A deferred join is a technique that defers access to requested columns until after the offset and limit have been applied.

In our case we don't actually do a join, but rather a where in with a subquery. Using this technique we create a subquery that can be optimized with specific indexes for maximum speed and then use those results to fetch the full rows.

The benefits can vary based on your dataset, but this method allows the database to examine as little data as possible satisfy the user's intent."

Creator

Aaron Francis
@aarondfrancis

Social Media Links

Related Projects


Laravel SOAP Laravel Soap Client
#API #Utility
icon-eye-dark Created with Sketch. 2.365
Laravel Notify Flash Notifications
#Utility #Plugins
icon-eye-dark Created with Sketch. 15.415
Sentry for Laravel Laravel Application Monitoring
❤️ Sponsored by Friends
We’re hosting on Digital Ocean! 💙 Try it today and get a free $100 credit.
try now
Fast Excel Excel Import/Export
#Utility
icon-eye-dark Created with Sketch. 10.004
Snooze Scheduling for Notifications & Reminders
#Utility
icon-eye-dark Created with Sketch. 3.001
View all Projects
COMMUNITY SPONSORS
Placid is a creative automation API & toolkit #madewithlaravel that lets you generate custom visuals at scale Learn more SaaSykit is a Laravel SaaS Starter Kit that comes packed with all components needed to run a modern SaaS app Learn more Laravel application monitoring by Sentry provides actionable insights to resolve performance bottlenecks and errors Learn more