> Documentation index: https://firebase.google.com/docs/database/llms.txt

There are a few different ways to improve Firebase Realtime Database
performance in your app. To find out what you can do to optimize your
Realtime Database performance, gather data through the different Realtime Database
monitoring tools, then make changes to your app or Realtime Database use accordingly.

## Monitor Realtime Database performance

You can gather data about your Realtime Database's performance through a few
different tools, depending on the level of granularity you need:

- **High-level overview:** Use the [the profiler tool](https://firebase.google.com/docs/database/usage/profile.md.txt) for a list of unindexed queries and a realtime overview of read/write operations.
- **Billed usage estimate:** Use the [usage metrics](https://firebase.google.com/docs/database/usage/billing.md.txt#console-usage) available in the [Firebase console](https://console.firebase.google.com/project/_/database/usage/current-billing/) to see your billed usage and high-level performance metrics.
- **Detailed drilldown:** Use [Cloud Monitoring](https://firebase.google.com/docs/database/usage/monitor-performance.md.txt#stackdriver-monitoring) for a more granular look at how your database is performing over time.

> [!IMPORTANT]
> **Check for bugs:** Before you start implementing any changes to your app, verify that it's syncing data the way you originally intended. To pinpoint issues, turn on debug logging in the [Android](https://firebase.google.com/docs/reference/android/com/google/firebase/database/Logger.md.txt), [Objective-C](https://firebase.google.com/docs/reference/ios/firebasecore/api/reference/Enums/FIRLoggerLevel.md.txt), and [Web](https://firebase.google.com/docs/reference/js/database.md.txt#enablelogging) SDKs. Check background and sync processes in your app to make sure it's downloading data at the frequency and volume you intended.

## Improve performance by metric

Once you've gathered data, explore the following best practices and strategies
based on the performance area you want to improve.

| Performance improvement strategies at-a-glance |||
|---|---|---|
| **Metric** | **Description** | **Best practices** |
| Load/Utilization | Optimize how much of your database's capacity is in use processing requests at any given time (reflected in \*\*Load\*\* or \*\*io/database_load\*\* metrics). | [Optimize your data structure](https://firebase.google.com/docs/database/usage/optimize.md.txt#data-structure) [Shard data across databases](https://firebase.google.com/docs/database/usage/optimize.md.txt#shard-data) [Improve listener efficiency](https://firebase.google.com/docs/database/usage/optimize.md.txt#efficient-listeners) [Limit downloads with query-based rules](https://firebase.google.com/docs/database/usage/optimize.md.txt#query-rules) [Optimize connections](https://firebase.google.com/docs/database/usage/optimize.md.txt#open-connections) |
| Active connections | Balance the number of simultaneous, active connections to your database to stay under the 200,000-connection limit. | [Shard data across databases](https://firebase.google.com/docs/database/usage/optimize.md.txt#shard-data) [Reduce new connections](https://firebase.google.com/docs/database/usage/optimize.md.txt#open-connections) |
| Outgoing bandwidth | If the downloads from your database seem higher than you want them to be, you can improve the efficiency of your read operations and reduce encryption overhead. | [Optimize connections](https://firebase.google.com/docs/database/usage/optimize.md.txt#open-connections) [Optimize your data structure](https://firebase.google.com/docs/database/usage/optimize.md.txt#data-structure) [Limit downloads with query-based rules](https://firebase.google.com/docs/database/usage/optimize.md.txt#query-rules) [Reuse SSL sessions](https://firebase.google.com/docs/database/usage/optimize.md.txt#ssl-sessions) [Improve listener efficiency](https://firebase.google.com/docs/database/usage/optimize.md.txt#efficient-listeners) [Restrict access to data](https://firebase.google.com/docs/database/usage/optimize.md.txt#secure-data) |
| Storage | Make sure you're not storing unused data, or balance your stored data across other databases and/or Firebase products to remain under quota. | [Clean up unused data](https://firebase.google.com/docs/database/usage/optimize.md.txt#cleanup-storage) [Optimize your data structure](https://firebase.google.com/docs/database/usage/optimize.md.txt#data-structure) [Shard data across databases](https://firebase.google.com/docs/database/usage/optimize.md.txt#shard-data) [Use Cloud Storage for Firebase](https://firebase.google.com/docs/storage.md.txt) |

## Optimize connections

RESTful requests like `GET` and `PUT` still require a connection, even though
that connection is short-lived. These frequent, short-lived connections
can actually add up to significantly more connection costs, database load, and
outgoing bandwidth than realtime, active connections to your database.

Whenever possible, use the native SDKs for your app's platform, instead of the
REST API. The SDKs maintain open connections, reducing the SSL encryption costs
and database load that can add up with the REST API.

If you do use the REST API, consider using an HTTP keep-alive to maintain an
open connection or use
[server-sent events](https://firebase.google.com/docs/reference/rest/database.md.txt#section-streaming),
which can reduce costs from SSL handshakes.

## Shard data across multiple databases

Splitting your data across multiple Realtime Database instances, otherwise known as
database sharding, offers three benefits:

1. Increase the total simultaneous, active connections allowed on your app by splitting them across database instances.
2. Balance load across database instances.
3. If you have independent groups of users that only need access to discrete data sets, use different database instances for higher throughput and lower latency.

If you're on the [Blaze pricing plan](https://firebase.google.com/pricing.md.txt), you can create multiple
database instances within the same Firebase project, leveraging a common user
authentication method across database instances.

Learn more about how and when to [shard data](https://firebase.google.com/docs/database/usage/sharding.md.txt).

## Build efficient data structures

Because Realtime Database retrieves the data from a path's child nodes as well as
the path, it makes sense to keep your data structure as flat as possible.
This way, you can selectively retrieve the data you need, without also
downloading unnecessary data to clients.

In particular, consider writes and deletes when you're structuring your data.
For example, paths with thousands of leaves are potentially expensive to delete.
Splitting them up into paths with multiple subtrees and fewer leaves per node
can speed up deletes.

Additionally, each write can take up 0.1% of your total database utilization.
Structure your data in a way that allows you to batch writes into a single
operation as multi-path updates through either the `update()` methods in the
SDKs or RESTful `PATCH` requests.

To optimize your data structure and improve performance, follow the
[best practices for data structures](https://firebase.google.com/docs/database/ios/structure-data.md.txt#best_practices_for_data_structure).

## Prevent unauthorized access

Prevent unauthorized operations on your database with
Realtime Database Security Rules. For example, using rules could avoid a scenario where a
malicious user repeatedly downloads your entire database.

Learn more about [using Firebase Realtime Database Rules](https://firebase.google.com/docs/database/security.md.txt).

## Use query-based rules to limit downloads

Realtime Database Security Rules restrict access to data in your database, but they can also
serve as limits on data returned through read operations. When you use
query-based rules, as defined by `query.` expressions like `query.limitToFirst`,
queries only retrieve the data bounded by the rule.

For example, the following rule limits read access to only the first 1000
results of a query, as ordered by priority:

    messages: {
      ".read": "query.orderByKey &&
                query.limitToFirst <= 1000"
    }

    // Example query:
    db.ref("messages").limitToFirst(1000)
                      .orderByKey("value")

Learn more about [Realtime Database Security Rules](https://firebase.google.com/docs/database/security.md.txt).

## Index queries

[Indexing your data](https://firebase.google.com/docs/database/security/indexing-data.md.txt) reduces the total
bandwidth you use for each query your app runs.

## Reuse SSL sessions

Reduce SSL encryption overhead costs on resumed connections by issuing
[TLS session tickets](https://tools.ietf.org/html/rfc5077). This is particularly
helpful if you do require frequent, secure connections to the database.

## Improve listener efficiency

Place your listeners as far down the path as you can to limit the amount of data
they sync. Your listeners should be close to the data you want them to get.
Don't listen at the database root, as that results in downloads of
your entire database.

Add queries to limit the data that your listen operations return and use
listeners that only download updates to data --- for example, `on()` instead of
`once()`. Reserve `.once()` for actions that truly don't require data updates.
Additionally, sort your queries using `orderByKey()`, whenever possible, for the
best performance. Sorting with `orderByChild()` can be 6-8 times slower, and
sorting with `orderByValue()` can be very slow for large data sets, since it
requires a read of the entire location from the persistence layer.

Make sure to also add listeners dynamically, and remove them when they're no
longer necessary.

## Clean up unused data

Periodically remove any unused or duplicate data in your database. You can
run [backups](https://firebase.google.com/docs/database/backups.md.txt) to manually inspect your data or
periodically back it up to a Google Cloud Storage bucket. Also
consider hosting stored data through [Cloud Storage for Firebase](https://firebase.google.com/docs/storage.md.txt).

## Ship scalable code you can update

Apps built into IoT devices should include scalable code that you can
update easily. Make sure to test use cases thoroughly, account for scenarios
where you might grow your userbase exponentially, and build in the ability
to deploy updates to your code. Carefully consider major changes you might need
to make down the line, if, for example, you decide to shard your data.