Hello,
We are running a compressing on two Large tables (~10million and ~100million rows). Using the compress proc we reduce their physical size by a ratio of 7.3:1.
Performance of the report viewer seems to degrade as the number of rows is increased. Does this mean the report attempts to uncompress the entire table or just the blocks that are required depending on the variables that are selected?
Thanks in advance!
I have found this on reference guide:
Performance Considerations
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.