flask-mongoengine icon indicating copy to clipboard operation
flask-mongoengine copied to clipboard

Pagination is pretty slow with large dataset

Open italomaia opened this issue 11 years ago • 1 comments

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?

italomaia avatar Dec 23 '14 21:12 italomaia

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

ripperdoc avatar Mar 06 '16 11:03 ripperdoc