https://communities.sas.com/t5/SAS-Web-Report-Studio/Several-SP-in-one-page/m-p/15063#M169 Hi <BR /> <BR /> I have a WRS page that calls 9 SP. Each of them selects data on tables, makes calculation etc... this is very long and it seems that I can sum the time execution of the SP to have the total time. For example, each SP execution time is 3s, so the page appears after 3s*9SP=27s.<BR /> <BR /> Correct me if I'm wrong but when I open the page it seems that the 9 SP are not executed in parallel. Is it possible ?<BR /> <BR /> How can I increase the performance in this case ?<BR /> <BR /> Thank you for your help.<BR /> <BR /> Stéphane. Tue, 04 May 2010 19:48:35 GMT Stephane 2010-05-04T19:48:35Z https://communities.sas.com/t5/SAS-Web-Report-Studio/Several-SP-in-one-page/m-p/15063#M169 Hi <BR /> <BR /> I have a WRS page that calls 9 SP. Each of them selects data on tables, makes calculation etc... this is very long and it seems that I can sum the time execution of the SP to have the total time. For example, each SP execution time is 3s, so the page appears after 3s*9SP=27s.<BR /> <BR /> Correct me if I'm wrong but when I open the page it seems that the 9 SP are not executed in parallel. Is it possible ?<BR /> <BR /> How can I increase the performance in this case ?<BR /> <BR /> Thank you for your help.<BR /> <BR /> Stéphane. Tue, 04 May 2010 19:48:35 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Several-SP-in-one-page/m-p/15063#M169 Stephane 2010-05-04T19:48:35Z