---
schema_version: "1"
id: e0a8c53626744877957a285af19a074cb27491446b1935426184f132830ea1fa
title: Best Practices
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-large-data-volumes-bp/guides/cce/ldv-deployments/ldv-deployments-best-practices.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-best-practices.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: e2babbca4cbd8406b4290aa20fa129de07c26fb99e07352f216d6d6c9b71e3fa
products:
  - Best Practices for Deployments with Large Data Volumes
  - Platform Developer Content
---

# Best Practices

This section lists best practices for achieving good performance in deployments with large data volumes.

The main approaches to performance tuning in large Salesforce deployments rely on reducing the number of records that the system must process. If the number of retrieved records is sufficiently small, the platform might use standard database constructs like indexes or de-normalization to speed up the retrieval of data.

Approaches for reducing the number of records include:

-   Reducing scope by writing queries that are narrow or selective

    For example, if the Account object contains accounts distributed evenly across all states, then a report that summarizes accounts by cities in a single state is much broader—and takes longer to execute—than a report that summarizes accounts by a single city in a single state.

-   Reducing the amount of data kept active

    For example, if your volume of data is increasing, performance can degrade as time goes by. A policy of archiving or discarding data at the same rate at which it comes into the system can prevent this effect.


These tables feature major goals and the best practices to follow to achieve those goals.

-   **[Reporting](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-best-practices-reporting.md)**  

-   **[Loading Data from the API](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-best-practices-api-loading-data.md)**  

-   **[Extracting Data from the API](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-best-practices-api-extracting-data.md)**  

-   **[Searching](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-best-practices-searching.md)**  

-   **[SOQL and SOSL](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-best-practices-soql-and-sosl.md)**  

-   **[Deleting Data](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-best-practices-deleting-data.md)**  

-   **[General](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-best-practices-general.md)**