+ Start a Discussion
Viraj MViraj M 

Can i do complex calculations with Salesforce object for millions records

If yes, How good it is in terms of performance when compare to SQL Database Stored Procs
Andrew EchevarriaAndrew Echevarria
Hey again!

I looked into this for you! You can do it via Batch Apex
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_batch_interface.htm

So the link above may be totally confusing, so here's an example of someone who implemented batch apex so you can get an idea of how it works:
http://salesforce.stackexchange.com/questions/99362/batch-apex-for-millions-of-records

Would this help? It might depend on the calculations you're running too and what you need at the end. If it's just math and your final output will be a series of numbers then it shouldn't be a problem.
Viraj MViraj M
Thanks for the reply I will go through it,