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