MongoEngine / flask-mongoengine

MongoEngine flask extension with WTF model forms support
Other
840 stars 256 forks source link

Pagination is pretty slow with large dataset #119

Open italomaia opened 9 years ago

italomaia commented 9 years ago

I have a 90.000 pages result here. Pagination chokes real hard when I try to access the last page. Here is some info about it: http://sammaye.wordpress.com/2012/05/25/mongodb-paging-using-ranged-queries-avoiding-skip/

Would there be anything to add to flask-mongoengine to make pagination more robust with large datasets or the solution from the link is the way to go?

ripperdoc commented 8 years ago

I understand that the new aggregation api for MongoDB should be able to to ranged queries much more performant, could be considered.