topic Optimising SAS VIYA Jobs in SAS Viya

Optimising SAS VIYA Jobs

smm662002 — Wed, 08 Jan 2025 13:13:33 GMT

Hello,

SAS VIYA LTS 2023.03

I have created a SAS VIYA Job using a simple HTML form using two text box which are linked to a proc fedsql running in CAS.

The input and output tables of the proc fedsql are in CAS.

When proc fedsql is executed with hard coded values in the where statement the running time is about 15 seconds.

When proc fedsql is executed with the values from the SAS Job (via the HTML form) in the where statement the running time is about 5 minutes.

The same values have been used via HTML form and hard coded and also the same input and output tables.

Can anyone please help with suggestions that can reduce the running time of the SAS Job?

Thank you,

smm662002

SASKiwi — Wed, 08 Jan 2025 19:51:21 GMT

I suggest you open a Tech Support track for this, as it looks to me more like a web server performance issue that needs troubleshooting.

smm662002 — Thu, 09 Jan 2025 12:52:29 GMT

Hi,

Thank you for your answer.

Would it be possible to advise of any installation parameters that can be changed to optimize the response time?

I still hope that someone in the SAS community had similar issues and maybe can share their solutions, before I open a ticket.

Thank you,

smm662002