How to avoid salesforce Soql governor limits

Salesforce enforces governor limits on SOQL DML operation, so its very important for developers to keep in to consideration before doing any DML operation

You can do following steps to avoid Soql limit issue

  • Avoid using Soql statement inside a loop. 
For instance avoid using code similar to one shown below
If you want to query an object then its better to store that in a collection and use that collection inside the loop something like this


We have used Contact map to store the contact data in the collection where accountid is used as key
  • Avoid using DML statements inside loops. 
For instance below code will trigger Soql limit error
To avoid Soql limit error you need to use collection and do a collection insert
As shown below






Comments

Post a Comment

Popular posts from this blog

The Salesforce Certification Frenzy: Balancing Quantity with Quality in a Changing Market

Image
In the evolving world of Salesforce, certifications have become an increasingly hot topic. Many professionals are relentlessly pursuing certification after certification, while businesses have begun to question the true value of these credentials. On the one hand, certifications can validate a candidate's knowledge and commitment, but on the other, they do not necessarily reflect an individual's ability to deliver high-quality, practical solutions. This trend has raised concerns about the certification-heavy culture within the Salesforce ecosystem, leading to a pivotal question: Is it time to prioritize real-world experience and problem-solving skills over a lengthy list of credentials? 1. Certifications: Valuable or Overhyped? Salesforce certifications were designed to ensure professionals possess a certain level of knowledge across various domains, like security, architecture, and specific functionalities within the platform. However, a growing number of individuals are colle...
Read more

The Ultimate Guide to Building a Salesforce Career: Roles, Skills, and Strategies for Success

Image
 The Salesforce ecosystem is vast and dynamic, offering multiple career paths for those interested in tech, business, and management. Whether you’re considering a role as an Administrator, Consultant, Developer, Architect, or Manager, this guide will help you understand what each position entails, the skills required, and tips for staying relevant in a competitive market. We’ll also touch on handling slow job markets, utilising volunteer roles to build experience, and the importance of certifications and continuous learning. 1. Salesforce Administrator Salesforce Administrators are the backbone of an organisation’s Salesforce environment. They ensure smooth day-to-day operations and handle configurations, user support, and data management, adapting Salesforce to meet business needs. Day-to-Day Role: User Management and Support: Admins manage users, assign roles, reset passwords, and ensure everyone has the appropriate level of access. Data Integrity and Maintenance: Maintaining a...
Read more