PerformanceIssuewithover2millionrecords

• Laravel-mongodb Version: laravel: 5.7, jenssegers: 3.4


• PHP Version: 7.2


• Database Driver & Version: mondodb: 3.4

simple queries like User::where('role', 'some_role')->where('name', 'some name')->orderBy('created_at', 'desc')->paginate(15); takes forver and time out occours with over 2 million records even after indexing the fields.

Steps to reproduce

1. populate users collection with 25 lack records


2. perform the above query


3. query puts a load on db server and queries start choking

Expected behaviour

Query should get executed, the same query, when changed to raw mongo query, and run on mongo shell, returns results in few milliseconds.

Actual behaviour

Query fails

Question :

Is this package recommended for application with millions of users and has huge data?
Kindly help here

Logs:
Insert log.txt here (if necessary)

该提问来源于开源项目：jenssegers/laravel-mongodb