Traditional web-based reporting with SAS BI tools

Several SP in one page

Reply
Contributor
Posts: 73

Several SP in one page

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.
Ask a Question
Discussion stats
  • 0 replies
  • 140 views
  • 0 likes
  • 1 in conversation