Why Firestore performance needs planning in Firebase - See It in Action

Why Firestore Performance Needs Planning

📖 Scenario: You are building a simple app that stores user profiles in Firestore. You want to understand how to organize your data and queries so the app runs fast and costs less.

🎯 Goal: Learn how to plan Firestore data structure and queries to improve performance and reduce costs.

📋 What You'll Learn

Create a Firestore collection with user profiles

Add a configuration variable for query limits

Write a query to fetch user profiles with limits

Add an index configuration for efficient queries

💡 Why This Matters

🌍 Real World

Apps that store and retrieve user data need fast and cost-effective database queries.

💼 Career

Understanding Firestore query planning is important for cloud developers and database administrators to optimize app performance.

1

Create a Firestore collection with user profiles

Create a Firestore collection called users with documents that have fields name (string) and age (number). Add exactly three users: {name: 'Alice', age: 30}, {name: 'Bob', age: 25}, and {name: 'Charlie', age: 35}.

Firebase

# Your code here to create the users collection with three user documents

Hint

Use an array of objects to represent the users collection.

2

Add a configuration variable for query limits

Add a variable called maxResults and set it to 2. This will limit how many user profiles we fetch at once.

Firebase

const users = [
  { name: 'Alice', age: 30 },
  { name: 'Bob', age: 25 },
  { name: 'Charlie', age: 35 }
];

// Your code here to add maxResults variable

Hint

Use const maxResults = 2; to set the limit.

3

Write a query to fetch user profiles with limits

Write a Firestore query called query that fetches documents from the users collection, ordered by age, and limited to maxResults.

Firebase

const users = [
  { name: 'Alice', age: 30 },
  { name: 'Bob', age: 25 },
  { name: 'Charlie', age: 35 }
];

const maxResults = 2;

// Your code here to create the Firestore query with order and limit

Hint

Use firestore.collection('users').orderBy('age').limit(maxResults) to build the query.

4

Add an index configuration for efficient queries

Add a Firestore index configuration JSON object called indexConfig that defines an index on the users collection with fields age ascending and name ascending.

Firebase

const users = [
  { name: 'Alice', age: 30 },
  { name: 'Bob', age: 25 },
  { name: 'Charlie', age: 35 }
];

const maxResults = 2;

const query = firestore.collection('users').orderBy('age').limit(maxResults);

// Your code here to add indexConfig JSON object

Hint

Define indexConfig as a JSON object with collection, queryScope, and fields array.

Practice

1. Why is it important to plan Firestore performance before building your app?

easy

A. To increase the number of users automatically

B. To keep the app fast and reduce costs

C. To add more colors to the app interface

D. To make the app look prettier

Solution

1. Step 1: Understand Firestore performance impact

   Firestore charges and speed depend on how data is organized and accessed.

2. Step 2: Connect planning to app speed and cost

   Good planning reduces slow queries and unnecessary reads, keeping the app fast and affordable.

3. Final Answer:

   To keep the app fast and reduce costs -> Option B

4. Quick Check:

   Performance planning = fast app + low cost [OK]

Hint: Think about speed and cost before coding [OK]

Common Mistakes:

• Confusing appearance with performance
• Ignoring cost implications
• Assuming more users means better performance

2. Which Firestore feature helps speed up queries by pre-sorting data?

easy

A. Indexes

B. Security rules

C. Realtime listeners

D. Cloud Functions

Solution

1. Step 1: Identify Firestore features for query speed

   Indexes organize data to make queries faster by pre-sorting and filtering efficiently.

2. Step 2: Match features to their roles

   Security rules protect data, realtime listeners update data live, Cloud Functions run backend code; only indexes speed queries.

3. Final Answer:

   Indexes -> Option A

4. Quick Check:

   Indexes = faster queries [OK]

Hint: Indexes speed queries by sorting data [OK]

Common Mistakes:

• Confusing security rules with indexes
• Thinking realtime listeners speed queries
• Assuming Cloud Functions affect query speed

3. Given this Firestore query:
db.collection('users').where('age', '>', 18).orderBy('age').limit(5)
What is a key reason this query performs well?

medium

A. It reads all users without filters

B. It fetches data without any conditions

C. It orders by a field not indexed

D. It uses a limit to reduce data read

Solution

1. Step 1: Analyze query filters and limits

   The query filters users older than 18, orders by age, and limits results to 5, reducing data read.

2. Step 2: Understand impact on performance

   Using limit reduces the number of documents fetched, making the query faster and cheaper.

3. Final Answer:

   It uses a limit to reduce data read -> Option D

4. Quick Check:

   Limit reduces data read = better performance [OK]

Hint: Limit queries to reduce data read [OK]

Common Mistakes:

• Ignoring the effect of limit
• Assuming no filters means better speed
• Not considering index usage

4. You wrote this Firestore query:
db.collection('orders').where('status', '==', 'shipped').orderBy('date')
But it throws an error about missing index. What should you do?

medium

A. Create a composite index on 'status' and 'date'

B. Remove the orderBy clause

C. Change 'status' to 'date' in where clause

D. Use a realtime listener instead

Solution

1. Step 1: Understand Firestore index requirements

   Queries with filters and orderBy on different fields need a composite index to work.

2. Step 2: Fix the error by creating the needed index

   Creating a composite index on 'status' and 'date' satisfies Firestore's requirement and removes the error.

3. Final Answer:

   Create a composite index on 'status' and 'date' -> Option A

4. Quick Check:

   Composite index fixes missing index error [OK]

Hint: Create composite indexes for combined filters and sorting [OK]

Common Mistakes:

• Removing orderBy without reason
• Changing filter fields incorrectly
• Using realtime listeners to fix index errors

5. You want to design a Firestore database for a chat app with many users and messages. Which planning step improves performance best?

hard

A. Store messages in a single document per user to reduce reads

B. Store all messages in one big collection and query by user ID

C. Split messages into subcollections per chat room and index user ID

D. Avoid using indexes to save costs

Solution

1. Step 1: Consider data organization for scalability

   Storing messages in subcollections per chat room groups related data and limits query scope.

2. Step 2: Use indexes to speed up user-specific queries

   Indexing user ID in subcollections allows fast queries without scanning all messages.

3. Final Answer:

   Split messages into subcollections per chat room and index user ID -> Option C

4. Quick Check:

   Organize data + index fields = better performance [OK]

Hint: Group data by chat room and index user ID [OK]

Common Mistakes:

• Putting all messages in one collection causing slow queries
• Storing all messages in one document causing size limits
• Skipping indexes to save money but hurting speed