Timeline for Using Aggregate SOQL With Large Amounts of Data (> 500k records)
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 21, 2014 at 12:30 | comment | added | Mohith Shrivastava | You wont be able to do a DML with Read only attribute so you wont be able to save this data .what I would recommend is for this type of complex reporting use any reporting tool and perform reporting outside SFDC .Using apex with such huge volumes is going to be problematic | |
| Sep 21, 2014 at 10:05 | comment | added | yutaolife | Hi Mohith, thanks answer my question. But, my aggregate query need to insert to other object. So，all calculate need to in back-end. In this case, how to working on large aggregate? Or, if i post the query into vf pgae, can i use apex access page and get all data? | |
| Sep 21, 2014 at 8:56 | history | answered | Mohith Shrivastava | CC BY-SA 3.0 |