Skip to content

Instantly share code, notes, and snippets.

@dancinllama
Created January 16, 2015 21:11
Show Gist options
  • Save dancinllama/354ade4c7ec79573ed90 to your computer and use it in GitHub Desktop.
Save dancinllama/354ade4c7ec79573ed90 to your computer and use it in GitHub Desktop.
Thou shalt not put queries in for loops (Bad example)
List<Account> accList = new List<Account>([Select Id,Name From Account]);
for(Account acc : accList){
Integer numWithEmail = 0;
for(Contact cont : [Select Id,Email From Contact Where AccountId = :acc.Id]){
if(!String.isEmpty(cont.Email)){
numWithEmail++;
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment