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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.