allow to remove default sorting option by _id

Description

I have a problem to Performance for filter. I using filter on 12Billion record and using create index but i need >15m to filter 1000 record if using restheart, i using RoboMongo filter just <23s to filter 1000 record.
I checked and see that query RESTHeart send to MongoDB server addition one filter sort({_id:-1}). I think that this is idea very bad. I think that this is the root for the problem that a said above because i added sort({_date:-1}) in my filter and the time results just <23s.
Please fix it is next version. Performance so bad.

Environment

None

Activity

Show:
Andrea Di Cesare
December 26, 2016, 7:14 PM

GET /db/coll still returns data sorted by _id:-1 by default, however client can now request

GET /db/coll?sort={}

and have a not sorted query

sort or sort_by are aliases

Assignee

Andrea Di Cesare

Reporter

Andrea Di Cesare

Labels

None

Fix versions

Priority

Major
Configure