Скачать или смотреть Selective bulkification with advance logic an advanced technique for SOQL optimization in Salesforce

Selective bulkification with advanced logic is a technique in Salesforce development that involves categorizing records based on specific criteria before processing them. This technique aims to optimize the handling of records in bulk by selectively applying logic to subsets of records, rather than processing all records uniformly. This can help minimize the impact of governor limits and enhance the efficiency of your code.

Example Scenario:
Consider a scenario where you have a custom object named Opportunity with a custom field Stage__c. You want to update the Close Dates of opportunities based on their stages but want to apply different logic to opportunities in different stages.

Non-Optimized Approach:
In a non-optimized approach, you might iterate through all opportunities and update their Close Dates based on their stages.

List Opportunity opportunities = [SELECT Id, Stage__c FROM Opportunity];

for (Opportunity opp : opportunities) {
if (opp.Stage__c.equals('Prospecting')) {
opp.CloseDate = Date.today().addDays(30);
} else if (opp.Stage__c.equals('Qualification')) {
opp.CloseDate = Date.today().addDays(45);
} else if (opp.Stage__c.equals('Negotiation')) {
opp.CloseDate = Date.today().addDays(60);
} // Additional conditions and logic...
}

update opportunities;
Optimized Approach with Selective Bulkification:
To optimize the code using selective bulkification, you can categorize opportunities based on their stages before processing them. This way, you can apply specific logic to each category efficiently.

List Opportunity opportunities = [SELECT Id, Stage__c FROM Opportunity];

List Opportunity prospectingOpportunities = new List Opportunity ();
List Opportunity qualificationOpportunities = new List Opportunity ();
List Opportunity negotiationOpportunities = new List Opportunity ();
// Additional lists for other stages...

// Categorize opportunities based on their stages
for (Opportunity opp : opportunities) {
if (opp.Stage__c.equals('Prospecting')) {
prospectingOpportunities.add(opp);
} else if (opp.Stage__c.equals('Qualification')) {
qualificationOpportunities.add(opp);
} else if (opp.Stage__c.equals('Negotiation')) {
negotiationOpportunities.add(opp);
} // Additional conditions and logic...
}

// Apply logic to each category
for (Opportunity opp : prospectingOpportunities) {
opp.CloseDate = Date.today().addDays(30);
}

for (Opportunity opp : qualificationOpportunities) {
opp.CloseDate = Date.today().addDays(45);
}

for (Opportunity opp : negotiationOpportunities) {
opp.CloseDate = Date.today().addDays(60);
}

// Additional logic for other categories...

// Update opportunities
update prospectingOpportunities;
update qualificationOpportunities;
update negotiationOpportunities;
// Update other categories...
Benefits of Selective Bulkification with Advanced Logic:
Governor Limits Optimization:

By categorizing records before processing, you can minimize the impact of governor limits, such as the total number of records processed in a single transaction.
Efficient Use of Resources:

Selective bulkification allows you to apply specific logic efficiently to subsets of records, optimizing the use of system resources.
Modular and Readable Code:

Code becomes more modular and readable as logic for each category is isolated, making it easier to maintain and understand.
Scalability:

The approach is scalable as you can easily add new categories and logic without significantly impacting existing code.
Considerations:
Careful Categorization:

Ensure that the categorization logic accurately reflects the conditions you want for each category. Use maps or other data structures if the number of categories is dynamic.
Bulk DML Statements:

Be mindful of bulk DML statement limits. You might need to implement additional logic or batch processing if the number of records is exceptionally large.
Code Maintainability:

Keep the code maintainable by organizing it in a way that's easy to understand and update. Consider documenting the categorization criteria.
Conclusion:
Selective bulkification with advanced logic is a technique that optimizes the processing of records in Salesforce, making your code more efficient and scalable. By categorizing records based on specific criteria before applying logic, you can achieve better performance and make your code more modular and readable. Always consider the specific requirements of your use case and the nature of your data when implementing this optimization technique.