Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Improving performance of list view rules

Updated on September 22, 2020

 This presentation is part of the Designing and Building for Performance Self-Study Course.



Always look to the bottom of the rule for any associated warning messages.

PRPC has detected two properties, Code and BaseCost, which are not explicitly defined as database columns.

ListView report is running a database query to select the desired information.  However, all the information needed in this case is not stored in regular database columns. 

Why is this a potential problem?  When retrieving data, you must ensure the underlying table accessed by the ListView has column names that exactly match all the referenced property names of this ListView. If the request were to refer to only properties that map to database columns, then the pzPvStream would not be needed. However, one referenced property not exposed as a database column can cause the generated Select statement to read the pzPvStream column. This includes those properties used for filtering and sorting as well.

You can use PRPC's Database tool for viewing and modifying your database schema.

Creating database columns for properties, a process called "exposing a property," does not require long discussions with a DBA; rather, simply give the DBA the generated SQL.

To retain certain rows in the table, run the "resaver servlet" to populate the newly created columns.  (See the system administration guides for details.)

The more data, the longer it takes to run this resaver tool.  Exposing the required properties during design time can avoid this expensive operational step.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us