-
Type: Question
-
Resolution: Duplicate
-
Priority: Critical - P2
-
None
-
Affects Version/s: 3.2.11
-
Component/s: Index Maintenance, Storage
-
None
We have a large amount of data and applying pagination on it using below query:
db.collection.find().sort(
).skip(<no. of docs to skip>).limit(<no. of docs to display at once>)
But, I need to create something similar to clustered index i.e which can store sorted documents inorder to avoid in-memory sort at the time of query since the data set is large. Also, this needs to be done to reduce the execution time taken by the query.
According to the search results, MongoDB does not support clustered index. So, is there any workaround for the same?
- duplicates
-
SERVER-3294 Ability to keep data on disk in ~ index order
- Closed