Skip to content

Parents with more than 50K children can't participate in some rollup styles #1490

@aheber

Description

@aheber

Is your feature request related to a problem? Please describe.
If a parent record has more than 50K children then SOQL often can't produce the aggregate result necessary to calculate the rollup. SOQL has a hard limit on rows read during a transaction.

Describe the solution you'd like
It would be nice if DLRS could be smart enough to break the rollup calculation into chunks in extreme cases, processing a single parent in batches. Not sure how to do that safely and for which rollup styles it will be compatible.

Describe alternatives you've considered
Because this is a hard limit in Apex I don't know how to handle this in a single transaction so I don't know of any workarounds.

Additional context
This would be tricky to test and review. Takes a bit of work to stage an environment with enough records to do this but not outside of the storage capabilities. Should build test scenarios using Snowfakery.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions