New SF Dev - new question - large data sets

[k1n6]

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?

[ericthgirw]

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.