function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
k1n6k1n6 

New SF Dev - new question - large data sets

I'm contempting an integration with my customer retention program which needs to store and retrieve hundreds of thousands of records.  Is storing or retrieving that many records proven problematic for any developers here?

ericthgirwericthgirw

SQOL Statements top out at quering 50,000 records. There is also the option of the @ReadOnly attribute in Winter 12 - if your code fits the criteria (scheduled, webservice or VF controller method) you can retrieve up to 1 million rows, but you won't be able to make any changes to them.