laravel mongodb jenssegers allowDiskUse true

Question

I use laravel-mongodb by jenssegers. I want to query a huge amount of data with order by and this is my query :

$stores = \App\StoreTransaction::where('date_time','>',1489944515)
        ->orderBy('date_time', 'asc')->get();

But I got this error:

Sort exceeded memory limit of 104857600 bytes

I know I should add allowDiskUse true to my query but how can i add it to mongodb jenssegers package ?

I'm not sure that you want to get all the results into memory. You should be able to use a cursor to get N results paginated. — Oluwafemi Sule
– Oluwafemi Sule, Commented Feb 3, 2018 at 12:25
Try $stores = \App\StoreTransaction::where('date_time','>',1489944515) ->orderBy('date_time', 'asc')->paginate(100) to get 100 records per time into memory. I'm not sure but I hope that this is implemented lazily. Otherwise, you want to do this using the cursor from a raw database command — Oluwafemi Sule
– Oluwafemi Sule, Commented Feb 3, 2018 at 12:29

Matthew Alika · Accepted Answer · 2019-09-24 12:46:29Z

6

Please do not modify vendor files

In your case, use the "options" method to allow disk use:

$stores = \App\StoreTransaction::where('date_time','>',1489944515)        
->orderBy('date_time', 'asc')
->options(['allowDiskUse' => true])
->get();

answered Sep 24, 2019 at 12:46

Matthew Alika

3784 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hoa can we done this when using aggregate query?

Bruno Rodriques Holanda · Accepted Answer · 2019-01-04 17:30:13Z

-1

Goto "vendor/mongodb/mognodb/src/Operation/Aggregate.php" Goto "line 133"

replace 'allowDiskUse' => false, per 'allowDiskUse' => true.

answered Jan 4, 2019 at 17:30

152 bronze badges

Editting vendor code is not a good suggestion. As it's easy to lose sight where the changes were made and can cause weird and hard to find bugs.