How Much Data Can the Salesforce Platform Handle? You Might Be Surprised!

Posted taken from STEVE BOBROWSKI | Published: FEBRUARY 15, 2013,www.allsalesforce.com/articles/

How Much Data Can the Salesforce Platform Handle? You Might Be Surprised!

Lots of you reading this post might have a preconceived notion of how much data a typical Sales Cloud or Force.com app can handle. The truth is that as salesforce.com popularity has skyrocketed, so too has the size of databases underlying custom and standard app implementations on our cloud platforms. It might surprise you to learn that our team works regularly with customers that have large Force.com objects upwards of 10 million records.

Best Practices for Large Data Volumes on Salesforce

Being successful with large data volumes on Force.com requires a knowledge of and implementation according to many best practices around data management. For example, here are a couple examples.

Problem Best Practices
Slow report on a large object
  • Document your org’s indexed fields.
  • Learn index selectivity rules.
  • Build reports that use indexes.
Slow bulk data load
  • Cleanse and transform data pre-load.
  • Disable triggers, validations, and workflow rules pre-load.
  • Use the Bulk API.

 

Some best practices are simple, while others are a bit more challenging. In any case, I’m not going to list all such best practices for Force.com data management here in this post. For a complete list, please read Best Practices for Deployments with Large Data Volumes.

Distributed Apps and Big Data

Every individual application platform has practical limits, and that’s when distributed processing make sense. By integrating different systems together to support a single app, you can scale your app to new heights.

Just as with other platforms, individual components within the Salesforce Platform each have practical limits, which shouldn’t surprise you. But the beauty of the platform is that it’s very easy to integrate different components, share state, authentication, and access controls, and thus support tremendous amounts of data for even the most demanding big data app.

The Power of the Salesforce Platform

To realize what’s possible with the Salesforce Platform for managing large amounts of data, consider the scenario in the following illustration.

image001-1024x478

To maintain lightning fast access to operational data in the Sales Cloud, you can create an app on Heroku that manages historical data. You keep your Sales Cloud org lean, are in compliance with your record keeping requirements, and can optimize the Heroku app and database to deliver the analytics you need on those historical records.

On top of it all, you glue together the UIs of your two apps using Force.com Canvas. This technology lets you embed the UI of a remote app within a Force.com app or customized Salesforce app, such that users don’t even realize they are getting data from outside.

Pretty cool and relatively easy to implement. Don’t believe me? See for yourself.