BookmarkSubscribeRSS Feed
Stephane
Quartz | Level 8
Hi

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.

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 ?

How can I increase the performance in this case ?

Thank you for your help.

Stéphane.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 0 replies
  • 848 views
  • 0 likes
  • 1 in conversation