Salesforce Solution Design – Performance considerations

Recently for one of our fortune 50 client, I was assigned to improve performance on page load and also on record save. As part of this we have done a detailed analysis and improved Salesforce performance by 40% with various design changes. So I would like to share all our learnings from this 1 year exercise with all Salesforce developers and Architects.

We will cover the background of project and how we fixed it with Query Optimization, Pageload Performance, Aysnc processes and Lazy loading. The major areas I would like to cover is:

Process Builder Vs Trigger Vs Flow Vs InvocableMethods
• Mainly when to use what
• Order of execution
• Process Builder and flow => SOQL and DML consumption details
• CPU time used

Query performance Improvement
• Filters, indexing, skinny Tables
• Query plan Tool usage
• Relationship query

Usage of asynchronous Operations to improve record save time
• Asynchronous Triggers
• @future
• Page load Performance

Design considerations in classic and lightning for better page load performance
• Lazy loading
• Inline VF pages
• Iframes
• Lightning pages

How to Get Performance Details

Query Optimization

  • Query Plan Tool
  • Indexed Fields
  • Query Filters
  • Skinny Tables
  • Avoid null conditions
  • Deleted Records in Recycle Bin

Page Load Performance

  • Remove unused fields & related list
  • Archive
  • Lazy Loading
  • Enable Separate Related List Loading
  • Use standard visualforce features
  • Use with Sharing with Apex Class


Date     : Saturday, May 30, 2020 10:00 AM EST (7:30 PM IST)
Where : YouTube
Speaker : Meera Nair

Further learning

Please Subscribe to the channel to get notification for upcoming recording.

If you are new in Salesforce. Please check our free Salesforce Admin and Salesforce Developer training.

Salesforce Apex Hours


  1. Reply
    Ishaan says:

    The recorded video says it is private

    • Reply
      Amit Chaudhary says:

      It will be live stream on YouTube at 10:00 AM EST (7:30 PM IST)

  2. Reply
    Karim Gabriel says:

    It looks like the recording is private; I did subscribe to Salesforce Apex Hours on YouTube.

    Thanks in advance.

    • Reply
      Amit Chaudhary says:

      It will be live stream on YouTube at 10:00 AM EST (7:30 PM IST)

  3. Reply
    Ishaan Motwani says:

    Very nice video.. thanks for sharing the knowledge Meera and Amit.
    It will be great, if the pot used can be shared too.

    • Reply
      Amit Chaudhary says:

      Do you mean code ?

  4. Reply
    Ishaan Motwani says:

    Typo..I meant ppt.

Post a comment