vendredi 8 février 2019

Laravel paginate is so slow

I have a problem with pagination it's so slow in big data more than 25K rows I try to get products saved by user in database by using:

$products = Item::has('product_save');

and I add same condition ...

$products = $products->where('active', 0);

I use this line to paginate :

$products = $products->paginate(20);

the all query take 0.06865 second. but is so slow more than 4.9 seconds! how i can make it very fast?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire