01-05-2015 03:01 AM
Hello SAS Experts,
I would like to know if its possible to implement parallel processing in SAS Stored process servers. I know and have implemented the same in SAS Workspace servers but I'm not sure of its feisibility in SAS Stored Process servers.
The said build in which I'm thinking of implementing the same generates Excel outputs in the end and the same is meant to be executed from SAS Information Delivery Portal post its release.
Currently it enforces sequential processing of functionally independent modules one after the other which could be done in parallel to save time, but I'm unsure of its possibility in Stored process servers.
Please cionvey your thoughts.
02-18-2015 02:40 AM
When trying this, keep in mind that your HW should be able to to this in a reasonable manner. Starting up the parallel processes will take time and resources, and when those processes compete for resources (CPU cores, RAM, disk access), they may actually slow each other down so that the final result is worse (slower) than simple processing in succession.
A process that runs for 2 minutes and is repeated 10 times takes 20 minutes, but running the 10 processes in parallel may easily take you more than an hour, if your server is not designed for parallel work.