Data Aggregation

The customer needed to aggregate monthly and yearly metrics using standard reports. The customer’s monthly and yearly details were stored in custom objects with four million and nine million records, respectively. The reports were aggregating across millions of records across the two objects, and performance was less than optimal.

The solution was to create an aggregation custom object that summarized the monthly and yearly values into the required format for the required reports. The reports were then executed from the aggregated custom object. The summarization object was populated using batch Apex.

j

Introduction

Underlying Concepts

Infrastructure for Systems with Large Data Volumes

Techniques for Optimizing Performance

Best Practices

Large Data Volumes Case Studies

Data Aggregation

Custom Search Functionality

Indexing with Nulls

Rendering Related Lists with Large Data Volumes

API Performance

Sort Optimization on a Query

Multi-Join Report Performance

Summary

Previous Versions