I have one stored procedure which is too long and occurs more than a thousand times with different variables. Normal execution on Server takes around 3-4 hours to complete. That is why I want to execute that SP in parallel on the elastic server to speed up the processing.
First execution of SP is independent from second one. So, it is possible to run single SP on thousand thread with different variables. Is there any solution to execute SP in parallel or use Amazon lambda to run it through Node.js API services? Are there any other ways I can execute it in faster way except using elastic server?