topic Re: SAS STP Execution Time in Developers

SAS STP Execution Time

Grumbler — Tue, 19 May 2015 08:44:04 GMT

we have a STP that runs on SASAPP stored process server with streaming option since we need to return some graphics. the browser console indicates that the STP ran about 15 seconds. however, when i check the sas log of the STP code, the real time execution is nowhere near 15 seconds. any idea where is the extra time from? or the sas log real time isn't accurate? thanks.

Re: SAS STP Execution Time

Kurt_Bremser — Tue, 19 May 2015 09:17:43 GMT

Look at the CPU consumption of your jboss or whatever serves the web applications. Most time is probably spent there.

Re: SAS STP Execution Time

Grumbler — Fri, 29 May 2015 09:22:19 GMT

nevermind. found out it's due to x command. sas obviously doesn't capture any time in the log.

Re: SAS STP Execution Time

LinusH — Fri, 29 May 2015 11:10:27 GMT

Consider using filename pipe instead.

I assume at least real time will reflect the time spent with your host call.

Re: SAS STP Execution Time

jakarman — Fri, 29 May 2015 11:39:44 GMT

The real-time is the wall clock time and cpu-time the time spend added by multiple processors.
Those measurements are the ones a seen by the SAS process. That is excluding the transfer between SAS and the desktop.

It is excluding time spend by external processes (RDBMS or OS).

As you are talking about graphics you could also have something there. X11 may be used for that at the OS level (Unix types) that should be installed with the virtualization layer. As Unix admins do not like graphical approaches it is often omitted. Xvfb - Wikipedia, the free encyclopedia