• CRC
|
• Edit

Large Data Volumes

Salesforce.com packaged applications (SFA, Service and Support etc.) as well as custom applications built on the Force.com platform run on Salesforce’s highly scalable, multi-tenant infrastructure. As the volume of data increases it is important that architects pay special attention to scalability and performance. The areas that get affected with increased data volumes are reporting, data integration, search and sharing recalculation. The exact impact depends on several factors besides the volume of data – the sharing rules in effect, the types of reports being run etc.. As a rule of thumb, when the number of records for an object approaches a million it is important to look into scaling techniques. We will list the scaling techniques and other best practices on this page. The Salesforce partner enablement team can also help you with design reviews to fulfill the requirements.

Understanding Large Data Volume Requirements

The attached spreadsheet can help you collect your customer's data volume requirement and giving you an idea of which areas to focus on. Media:LDV_Customer_Requirement_Questions.zip

Tips & Techniques for dealing with Large Data Volumes

• Divisions
• The Bulk API is a new feature in Winter '10. The Bulk API is optimized to enable loading large amounts of data. The attached File:Bulk API.ppt will give you an idea of the capabilities. You can watch a demo of it here.
• Skinny Tables
• Custom Indexes
• Data partitioning/archiving - operational vs. reporting

Engaging Salesforce Partner Enablement Team

Salesforce partners can request assistance from the partner enablement team in addressing large data volume requirements. Please file a support ticket via partner portal and choose desig review. Also, capture the requirements using the spreadsheet above.

About the Authors

This page is maintained by Nick Simha (nsimha@salesforce.com) with the Partner Enablement Team at Salesforce