eloquent - How to reduce size of data in laravel for ajax response?

Question

I am fetching data from database which is returning almost 5000 records form database . when I see resource size over network it is 10 mb of size.

This table has almost fifty columns. Is there any way I can reduce the size which displaying in network tab of browser?

here is the query

$consignments = Consignment::query();
$consignments->where('delivery_run_id', null);
  
$consignments = $consignments->orderBy('id', 'desc')->limit(5000)->get();

return Response::json(['status' => 'success', 'consignment' => $consignments]);

i try to use select() but no effect

question from:https://stackoverflow.com/questions/65934201/how-to-reduce-size-of-data-in-laravel-for-ajax-response

Answer 1

try this

$consignments = $consignments->orderBy('id', 'desc')->limit(5000)->select(['column one','column two','column three']);