Practical limit of number of rows in collections
Hi
I use Apex3 and am thinking of using collections to solve a problem. The issue is, though in average each operation will create less than 1000 rows, there may be cases where as many as 100k rows will need to be created (but they will be very rare).
Basically the user will be able to upload a text file, and each line in the text file will generate a row in a collection, some calculations will be performed for each row and at the end the results will be displayed as a report.
Do you think it is reasonable to use collections in this case, or the number of rows can be create performance problems? Or should I put some limit on the number of rows the users can upload (in this case they will have to break big files in smaller ones)?
Thanks!
Luis