Hey Creators,

Welcome to the first post of Creator Simplified—a learning series designed to enhance your app development skills.  

1. //Poor performance 
2. for each rec in Students //Iterates through 100K records
3. { 
4. if(dept==“Computer Science”)
5. {
6. Send email;          
                }
   }

In this scenario, the script iterates through all the records until the "if" condition is met, when the requirement is just to filter out Computer Science students. Therefore it's not an efficient way to retrieve the desired records.

1. // Some what improved performance
2. for each rec in Students[dept ==“Computer Science”] //Iterates through only 10K records (assuming Computer Science student count is 10K)
3. {
4. Send email;
5. }

1. //Optimized performance
2. for each rec in Students[dept.equalsIgnoreCase(“Computer Science)]
3. //Iterates through only 10K records + applies index concept
4. {
5. Send email;
6. }