All Ideas

Idea Details

Post an Idea
This idea has been delivered and can no longer be voted or commented on. If you’d like to add to this conversation, please post a new idea.
14,190  Points voting closed
Delivered in Winter 16
Idea is generally available.

Bulkify Process Builder

Process Builders and Workflow

It appears that the new Lightining Process Builder (Beta) is running on the trigger flow engine, which has some bulk limitations. The Process Builder is great because it allows admins to easily build a process that would noramally have to be written in Apex. For example, the cross object limits do not apply to the Process Builder, so an admin can traverse as many relationships to look up values as well as update and create records. 

The problem that I have found is that each one of these lookups and updates uses a SOQL query. And because the process is not bulkified, like workflow rules, if the process is triggered on more than 100 records (perhaps during a mass update, or new lead upload), a trigger flow error is hit (caused by: Too many SOQL queries: 101). Also, each look up is it's own SOQL query, so if there are two lookups in the process uploads of 50 or more will fail, and so on.

I would like to see both the process builder and the trigger flow functionality bulkified, so admins can create great processes without having to move to Apex due to limits.

· Flag

Latest Comment from Salesforce

  • Jennifer Sacks - 2 years ago

    All, I have confirmed with the product manager that this idea is delivered in Winter '16. Record creates were already bulkified when we originally released process builder. The PM pointed out there is often a misunderstanding of what is causing most use cases to hit limits. The operation may be to create a bunch of records, but the queries associated are actually the main cause of limit errors. In such cases, you are hitting platform limits. At this point, Process Builder & Flow are as optimized and bulkified as possible. For those purely reacting to the details captured in the release notes, we will be updating that content to make it clearer. 

    If you have a platform limits use case, the PM would love to hear it as her team explores enhancements to overall limits. 
  • Upvotes
  • Downvotes

Ideas

Apps

from AppExchange

Questions

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.