Optimizing Laravel 5 & MySQL for 9M+ rows

Don’t use LengthAwarePaginator. Use Paginator, aka, simplePaginate.

Source: Optimizing Laravel 5 & MySQL for 9M+ rows. Step 1. — Medium