Introduction to MongoDB cursor.limit() Method

MongoDB is a popular NoSQL database that provides rich APIs and methods for manipulating data collections. Among them, the cursor.limit() method is a method that can limit the number of query results. Using this method can return only the specified number of results when there are too many query results, avoiding unnecessary resource waste.



The method returns a new cursor object that contains only the first n query results. Here, n is the number of results specified by the user.

Use cases

  1. When the query result set is very large, you can use the cursor.limit(n) method to return only the first n results to ensure query efficiency and performance.
  2. When we only care about the first few records of the query result set, we can also use the cursor.limit(n) method to limit the returned results.


The following example demonstrates how to use the cursor.limit(n) method to limit the number of results to 2:

from pymongo import MongoClient

# Connect to the database
client = MongoClient('mongodb://localhost:27017/')
db = client['testdb']
collection = db['test_collection']

# Insert 10 pieces of data into the collection
for i in range(10):
    collection.insert_one({'value': i})

# Query and limit the number of results to 2
cursor = collection.find().limit(2)

# Output the query results
for document in cursor:

Execution result:

{'_id': ObjectId('...'), 'value': 0}
{'_id': ObjectId('...'), 'value': 1}


The cursor.limit(n) method is a very useful query operation, which can limit the size of the query result set, improve query efficiency and performance. At the same time, we can also use other methods such as cursor.skip(n) and cursor.sort() to control the query result set and achieve more flexible query operations.