[SERVER-31357] Using Indexes To Sort Huge Data Created: 03/Oct/17 Updated: 07/Apr/23 Resolved: 03/Oct/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance, Storage |
| Affects Version/s: | 3.2.11 |
| Fix Version/s: | None |
| Type: | Question | Priority: | Critical - P2 |
| Reporter: | Pratiksha Aggarwal | Assignee: | Mark Agarunov |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Participants: | |||||||||
| Description |
|
We have a large amount of data and applying pagination on it using below query: ).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? |
| Comments |
| Comment by Mark Agarunov [ 03/Oct/17 ] |
|
Hello pragupta, Thank you for the report. Looking over this, you appear to be describing the same behavior as Thanks, |