Sorting and Limiting in MongoDB Cursor Operations

Sort and Limit Practice

Write a MongoDB query to find the top 10 most recent orders sorted by orderDate descending.

Expected output: A cursor returning 10 documents sorted from newest to oldest orderDate.

Hint: Use sort() with orderDate: -1 and limit(10).

Combine Sorting on Multiple Fields

Write a query to sort products first by category ascending, then by price descending.

Expected output: Documents sorted by category A-Z and within each category by price high to low.

Hint: Pass both fields in a single sort() call.

Sorting on indexed fields improves performance by allowing MongoDB to quickly order results. Sorting on non-indexed fields requires an in-memory sort, which can be slower and resource-intensive.

Using limit() without sort() returns an arbitrary subset of documents based on the natural order in the collection, which may not be predictable.

No, you should pass all sorting fields in a single sort() call as an object. Multiple sort() calls will override previous ones.