I’m working on a Laravel application that retrieves a large dataset from the database.
Currently, I’m fetching all results at once, but this is causing performance issues. I’d like to implement pagination to display the data in smaller chunks. What’s the most efficient way to achieve this using Laravel Eloquent and its relationships?

What I’ve tried:
I’ve tried fetching all results at once and limiting them in the view, but this is slow for large datasets.

Expected outcome:
I want to implement server-side pagination using Eloquent to retrieve only the necessary data for the current page, improving performance and user experience