search

SFDO-Community / declarative-lookup-rollup-summaries

Declarative Lookup Rollup Summaries (DLRS) is a community built and maintained Salesforce application that allows you to create cross object roll-ups declaratively - no code! For install instructions and documentation, visit our website https://sfdo-community-sprints.github.io/DLRS-Documentation/
https://sfdo-community-sprints.github.io/DLRS-Documentation/
BSD 3-Clause "New" or "Revised" License
690 stars 235 forks source link

Globally enable or disable real-time DLRS calculations #786

Open petervukovic opened 5 years ago

petervukovic commented 5 years ago

Background:

When doing mass record updates via Bulk API, and the record has DLRS triggers on it, Salesforce often throws System.LimitException: Too many SOQL queries as each record update is triggering a recalculation. The resolution is to temporarily deactivate DLRS on the affected records, then reactivate them once the bulk operation is completed. This is time consuming especially when the record is involved in multiple summaries.

Enhancement:

Introduce a global real-time switch that would allow users to enable or disable real-time calculations entirely in order to support mass record updates.

delan-flywheel commented 4 years ago

Hi Peter,

Did you ever find a workaround for this?

Thanks,

petervukovic commented 4 years ago

Unfortunately no.

On Thu, 12 Dec 2019 at 20:34, delan-flywheel notifications@github.com wrote:

Hi Peter,

Did you ever find a workaround for this?

Thanks,

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/afawcett/declarative-lookup-rollup-summaries/issues/786?email_source=notifications&email_token=AEJ77SGSCWRNS343HGSJAYTQYKG3NA5CNFSM4GTESOI2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEGXYTWQ#issuecomment-565152218, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEJ77SBSV7VLW3VSLCEYDOLQYKG3NANCNFSM4GTESOIQ .

JimBTek commented 4 years ago

Just use the lookup summary list view and edit the calc type on all you DLRS at once. Or undeploy the DLRS trigger temporarily and then redeploy it.

On Tue, Jan 29, 2019 at 6:29 PM petervukovic notifications@github.com wrote:

Background:

When doing mass record updates via Bulk API, and the record has DLRS triggers on it, Salesforce often throws System.LimitException: Too many SOQL queries as each record update is triggering a recalculation. The resolution is to temporarily deactivate DLRS on the affected records, then reactivate them once the bulk operation is completed. This is time consuming especially when the record is involved in multiple summaries.

Enhancement:

Introduce a global real-time switch that would allow users to enable or disable real-time calculations entirely in order to support mass record updates.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/afawcett/declarative-lookup-rollup-summaries/issues/786, or mute the thread https://github.com/notifications/unsubscribe-auth/ABHzGwxxXKONG9IHitlw68FvzItOl-Nnks5vINk9gaJpZM4aZJOR .

-- Best,

Jim Bartek BTek Ventures, LLC 317-292-6301 BTekVentures.com

afawcett commented 4 years ago

Flagg as enhancement for now, though i am sure this has been raised already.