When you need to load a very large amount of data into Force.com quickly, you want to ensure that each insert is as efficient as possible. With appropriate preparation and post-processing, you can disable data validation and enrichment operations while loading–without compromising your data integrity or business rules.
Tag Archives: architecture
Extreme Salesforce Data: Distributed Application Partitioning with Force.com Canvas and Heroku

Want to scale your Salesforce data set to new heights? Then check out this hands-on tutorial that shows you how to implement an external application to store historical records. You also learn how to integrate its UI and user authentication into Salesforce so that your users can analyze historical data right alongside operational data. This practical step-by-step guide uses a combination of Salesforce Platform technology, including Force.com, Heroku, and Force.com Canvas.
Force.com Performance Profiling Using the Developer Console

If you’ve built an application on the Force.com platform, you want to deliver a great experience to your users. But how can you tell if your applications are performing well and will continue to perform well? Using the Developer Console, you can use “performance profiling” to identify and fix performance hotspots, and ensure that your applications are both fast and scalable.
Extreme Force.com Data Loading, Part 2: Load into a Lean Salesforce Configuration
You are planning a Force.com implementation, with large volumes of data. Your data model is in place, all your code is written and has been tested, and now it’s time to load the objects, some of which have tens of millions of records. What is the most efficient way to get all those records into the system?
This is the second entry in the six-part series of blog posts about data loading for very large enterprise deployments, covering how to load data into a lean configuration.
Extreme Force.com Data Loading, Part 2: Loading into a Lean Salesforce Configuration

You are planning a Force.com implementation with large volumes of data. Your data model is in place, all your code is written and has been tested, and now it’s time to load the objects, some of which have tens of millions of records. What is the most efficient way to get all those records into the system?
This is the second entry in the six-part series about data loading for very large enterprise deployments, covering how you can load data into a lean configuration.
Managing Lookup Skew in Salesforce to Avoid Record Lock Exceptions
If you regularly perform Salesforce implementations with objects that store a lot of records, you probably already know about the strategies that you can use to appropriate manage and distribute your data. Some of the more obvious strategies include using indexes, skinny tables, archival strategies, and even divisions.
However, even if you choose the most appropriate strategy or strategies, you might miss a lesser-known “silent killer” within your architecture: lookup skew.
Read this blog post to learn both how lookup skew affects objects with large volumes of data and what you can do now to minimize its effects.
Designing Optimal SOQL Queries and Reports for Your Salesforce Apps

If you’re an advanced Force.com developer or architect, or someone who’s just interested in developing applications on the Force.com platform, get a peek behind the Force.com query optimizer curtain later this month. Register for the Inside the Force.com Query Optimizer webinar, which will be co-hosted by Technical Enablement’s own John Tan on April 23, 2013, at 7 a.m. and 10 a.m. PST.
Understanding Force.com Platform Internals Helps You Build Better Apps
Force.com Formula Fields, Indexes, and Performance Gotchas

Understanding Force.com internals can give you an edge in building applications that perform well, especially when your organization has a large volume of data. This blog post can help you get that edge. Read on to better understand formula fields, field indexes, and date field logic so that you can deliver SOQL queries, list views, and reports that fly rather than crawl.
Long- and Short-Term Approaches for Tuning Force.com Performance

Managing your Salesforce organization’s data is a crucial part of keeping your organization healthy, and you might have heard about one tool that can help it stay fit: skinny tables. Read this post to learn how skinny tables work, how they can help you with large volumes of data, and what you should consider before using them.

