Salesforce has a limitation of 50,000 records for any operation. 1,000,000 records for read-only operations. If you go beyond that, you talk to Salesforce abou

Salesforce has a limitation of 50,000 records for any operation. 1,000,000 records for read-only operations. If you go beyond that, you talk to Salesforce about it, because they can make adjustments for you - and you can likely afford it. Salesforce will bend over backwards and make internal engineering changes for large customers, including adjusting governor limits, dedicating hardware and running backend queries directly for the customer.