02-18-2016 02:08 PM
SAS can take a very long time to load an output table after you click on it from the process flow, is there a way to cancel it and return to the process flow window?
02-18-2016 02:24 PM
Not that I'm aware of. You can set a limit on the number of rows displayed which would speed things up. By default it is 1M rows. You could try reducing that to see if it helps. It is in the Tools - Options - Data - Performance settings.
02-18-2016 03:56 PM
Thanks for the tip. I actually have that setting set to 1,000 rows. Perhaps SAS struggles loading tables while executing a process simultaneously.
02-18-2016 07:22 PM
What kind of a table is it? If it's a SAS dataset, I've never seen this kind of problem. But if it's a database table, you're being held hostage to the DBMS. Particularly if the unerlying DBMS object is a view, the entire view might have to be created to show you any data at all.
02-19-2016 02:01 AM
The communication between EG and the workspace server seems to involve a lot of back-and-forth with small data chunks; if network I/O and server load becomes congested, the individual latencies of the requests add up to noticeable delays.
At least my experience around here with a rather old server (IBM P5 based). WIll have comparative values once we move to a new (P8) server.