https://communities.sas.com/t5/SAS-Visual-Analytics/Can-partitioning-help-to-increase-responsiveness-of-a-VA-report/m-p/988688#M18978 <P>In our reports we make an extensive use of filters and parameters and derived actions from one object on others.&nbsp;</P> <P>It works fine in terms of response time if, code-wise, I create a subset of the whole main table. To give you an idea, this might reduce the row count from 3.5 millions to&nbsp; 200.000 as our main filter criteria is the plant.</P> <P>We suffice with one unique report built with tables that live in caslibs that are accessible for all authorized report users. We control what they can see (plant bound) with the&nbsp;cas action&nbsp;<STRONG>accessControl.updSomeAcsTable</STRONG>. That works but it comes at the cost that the report is very slow sometimes.&nbsp;</P> <P>So I wonder if partitioning the table by plant would be a promising solution to explore.&nbsp;</P> Wed, 27 May 2026 09:05:59 GMT acordes 2026-05-27T09:05:59Z https://communities.sas.com/t5/SAS-Visual-Analytics/Can-partitioning-help-to-increase-responsiveness-of-a-VA-report/m-p/988688#M18978 <P>In our reports we make an extensive use of filters and parameters and derived actions from one object on others.&nbsp;</P> <P>It works fine in terms of response time if, code-wise, I create a subset of the whole main table. To give you an idea, this might reduce the row count from 3.5 millions to&nbsp; 200.000 as our main filter criteria is the plant.</P> <P>We suffice with one unique report built with tables that live in caslibs that are accessible for all authorized report users. We control what they can see (plant bound) with the&nbsp;cas action&nbsp;<STRONG>accessControl.updSomeAcsTable</STRONG>. That works but it comes at the cost that the report is very slow sometimes.&nbsp;</P> <P>So I wonder if partitioning the table by plant would be a promising solution to explore.&nbsp;</P> Wed, 27 May 2026 09:05:59 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Can-partitioning-help-to-increase-responsiveness-of-a-VA-report/m-p/988688#M18978 acordes 2026-05-27T09:05:59Z