Why performance tuning matters in MongoDB - See It in Action

Why Performance Tuning Matters in MongoDB

📖 Scenario: You are managing a small online bookstore using MongoDB. As the number of books and customers grows, you notice that some searches and updates are getting slower. To keep the store running smoothly and customers happy, you need to understand why performance tuning is important.

🎯 Goal: Build a simple MongoDB collection with book data, add an index to improve search speed, and observe how performance tuning helps queries run faster.

📋 What You'll Learn

Create a MongoDB collection named books with sample book documents

Add an index on the title field to speed up searches

Write a query to find books by title using the index

Explain why adding the index improves performance

💡 Why This Matters

🌍 Real World

Performance tuning is essential in real-world databases to keep applications fast and responsive as data grows.

💼 Career

Database administrators and developers use indexing and tuning to optimize queries and improve user experience.

1

Create the books collection with sample data

Create a MongoDB collection called books and insert these exact documents: { "title": "The Great Gatsby", "author": "F. Scott Fitzgerald", "year": 1925 }, { "title": "1984", "author": "George Orwell", "year": 1949 }, and { "title": "To Kill a Mockingbird", "author": "Harper Lee", "year": 1960 }.

MongoDB

// Insert the three book documents into the books collection
// Your code here

Need a hint?

Use db.books.insertMany() with an array of book objects.

2

Add an index on the title field

Create an index on the title field of the books collection using db.books.createIndex to help speed up searches by book title.

MongoDB

db.books.insertMany([
  { "title": "The Great Gatsby", "author": "F. Scott Fitzgerald", "year": 1925 },
  { "title": "1984", "author": "George Orwell", "year": 1949 },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "year": 1960 }
])
// Create an index on the title field
// Your code here

Need a hint?

Use db.books.createIndex({ title: 1 }) to create an ascending index on the title field.

3

Query books by title using the index

Write a query using db.books.find to find the book with the exact title "1984".

MongoDB

db.books.insertMany([
  { "title": "The Great Gatsby", "author": "F. Scott Fitzgerald", "year": 1925 },
  { "title": "1984", "author": "George Orwell", "year": 1949 },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "year": 1960 }
])
db.books.createIndex({ title: 1 })
// Find the book with title "1984"
// Your code here

Need a hint?

Use db.books.find({ title: "1984" }) to search for the book by title.

4

Explain why adding the index improves performance

Add a comment explaining that creating an index on the title field helps MongoDB find books faster by avoiding scanning every document.

MongoDB

db.books.insertMany([
  { "title": "The Great Gatsby", "author": "F. Scott Fitzgerald", "year": 1925 },
  { "title": "1984", "author": "George Orwell", "year": 1949 },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "year": 1960 }
])
db.books.createIndex({ title: 1 })
db.books.find({ title: "1984" })
// Explain why the index helps performance
// Your code here

Need a hint?

Write a comment starting with // explaining how the index speeds up searches.