Sunday, February 4, 2018

Important facts which needs to be considered while designing any solution which includes Large data volumes in Salesforce


  • Sharing calculation is even performed for records which are in recycle bin which may impact your performance. So if you don't need records then perform hard delete on records after archiving it.

  • Only Bulk API supports hard delete functionality.

  • Adding custom indexes on records may improve query performance but can degrade the performance of database insert and update. That is reason that Salesforce doesn't allow developers to add custom indexes by themselves. You have to raise support ticket and Salesforce will evaluate your use case before adding custom indexes. So always evaluate the pros and cons before adding any new custom indexes.

  • As a best practice, don't use formula fields in where clause in SOQL. It degrade the SOQL performance if it doesn't return deterministic values (formula returns pre-defined set of values which are repeatable).

  • Now Salesforce allow you to add custom index to formula fields only if it gives deterministic results

  • Use readonly attribute on VF page if you want to query more than 50 millions records and display the result on UI by processing those records.



4 comments:

  1. Great presentation of Salesforce form of blog and Salesforce tutorial. Very helpful for beginners like us to understand Salesforce course. if you're interested to have an insight on Salesforce training do watch this amazing tutorial.https://www.youtube.com/watch?v=jbV0j6kmQl4

    ReplyDelete
  2. Finally, we now can add a custom index to formula fields, it really was the feature that Salesforce lacked for so much time.

    ReplyDelete
  3. Very helpful for beginners like us to understand Salesforce course.
    Non Woven Gowns

    ReplyDelete
  4. Discover the elegant collection of kaftan dress design by Ammara Khan. Explore unique and stylish kaftan dress designs to enhance your wardrobe.

    ReplyDelete