can salesforce handle 50 or 70 million records?

Can salesforce handle 50 or 70 million records?

in the past I worked on the org which had 20 million tasks and it was real problem, so wanted to get experts thoughts on what is the impact if we import 50 or 70 million records in the system, any guidance ? best practices?

basically what is the max volume salesforce can handle for single object records.

Answer

Can a Salesforce instance contain 50+ million records? Almost certainly. I’ve seen instances with millions of records, although none as large as 50 million. A Salesforce sales person would be able to confirm the max size of a table, if there is one. (50 million records will get their attention and you can expect a quick answer.)

Would I recommend Salesforce as the primary data solution for a 50+ million record need? Usually not, for the following reasons:

  • Salesforce governor limits are generally toxic to big data. Take a look at the ironically named 38-page “Limits Quick Reference Guide” for what I’m talking about. The big ones you’ll run into are query limits, aggregate statement row limits, efficient query restrictions, batch job size limits, and batch job daily execution limits. In short, it will be difficult to create any sort of functionality around the data that requires custom code. If you just need to store the data and run limited reports on it, you would probably be fine, but if you need actual functionality that deals with the entire data set you will get frustrated quickly. That said, Salesforce has been murmuring about a true “big data” NoSQL-type solution in the near future, but it hasn’t been announced yet.
  • Data storage will be expensive. You’ll need to get a quote, but under Enterprise the data limit is 1GB + 20MB/user, and every row costs you a minimum of 2k of data quota. 50m rows will consume at least 100GB. Like I said, get a quote, but data is not cheap in the Salesforce world.

I’d be looking at ways to keep the high-volume data in an external big-data-friendly data store (Heroku, a Salesforce-owned company, would be an option — so would Amazon Web Services, hosted traditional SQL databases or NoSQL databases, and even locally-managed servers). And then synthesize the report-level data into summaries that are loaded into Salesforce to be used there.

Attribution
Source : Link , Question Author : user6704 , Answer Author : jkraybill

Leave a Comment