Download the PHP package elattar/fast-paginate without Composer
On this page you can find all versions of the php package elattar/fast-paginate. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package fast-paginate
Fast Paginate for Laravel
About
This is a fast limit/offset pagination macro for Laravel. It can be used in place of the standard paginate methods.
This package 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 SQL looks something like this:
You might get an error trying to run the query above! Something like
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery.In this package, we run them as two separate queries to get around that!
The benefits can vary based on your dataset, but this method allows the database to examine as little data as possible to satisfy the user's intent.
It's unlikely that this method will ever perform worse than traditional offset / limit, although it is possible, so be
sure to test on your data!
If you want to read 3,000 words on the theory of this package, you can head over to aaronfrancis.com/2022/efficient-pagination-using-deferred-joins.
Installation
This package supports Laravel 8, 9, and 10. (Laravel 8 must be 8.37 or higher.)
To install, require the package via composer:
There is nothing further you need to do. The service provider will be loaded automatically by Laravel.
Usage
Anywhere you would use Model::query()->paginate(), you can use Model::query()->fastPaginate()! That's it! The method signature is the same.
Relationships are supported as well:
A Favor
If this helps you, please tweet at me with before and after times! I'd love to know :D
Some community results so far:
