Greetings @Salesforce and @salesforcedevelopers community and of course, +Alex Gorbachev
I have a SFDC client looking to run large queries against accounts, contacts and a custom object call assets. They have 50,000,000 account and contact records and are interested in running this kind of query:
- communication opt-in is YES (contact attribute)
- English language or country: US, CA, AU, UK (asset attribute)
- any user type (query a value stored in an asset record)
The report would list the customer account, name, assets and could be summarized by user type, by country and obviously totaled.
I have reviewed the Best Practices for Deployments with Large Data Volumes, but before the team will scope the work and get to the bottom of the requirement, I would like to know if there are limits on query sizes and or time-out limits? Has anyone come across these limits or has salesforce.com
offered up the specifics of where a query against a production database will simply fall over? I found someone referencing a 3rd party system called heroku.com
. They list accounts such as Macy's, Toyota etc.
I would appreciate knowing what we are getting into. Feel free to reach me direct at andy dot church at onpath.com