Skip to main content
LinkedIn
Copied!

Table of Contents

Optimizing properties from the user interface

Version:

Only available versions of this content are shown in the dropdown

You can expose a property as a database column, and populate the new column by extracting values from the storage stream (BLOB or pzPVStream ) column, using the Property Optimization tool in a development system.

The Property Optimization tool creates a new database column and starts a background process that populates the values for the new column (for existing instances of this class only) from BLOB values. Background processing might take some time, depending on volume, and cause computations in your applications that involve the property value to fail or produce incorrect results until all background processing is complete.

You can also use this tool to "expose" values of an embedded property by automatically creating a concrete Index- class, properties for the new class, and a Declare Index rule that maintains the indexes. A background process creates the instances of the new Index- class.

You cannot optimize a transient property, because the column values would all be null. You cannot optimize properties in classes mapped to pr_other.

Your development environment must meet these prerequisites to use this tool:

  • The Pega-RulesEngine agent System-Job-PropertyOptimizationpyOptimization must be enabled for background processing.
  • The Data-Admin-DB-Name data instance named PegaRULES must identify, for either the primary database username and password, or the alternate Admin username and password, the credentials that allow the ALTER TABLE and CREATE TABLE functions for the database.

After you have satisfied the prerequisites, see Exposing properties and populating database columns for more information on using the Property Optimization tool.

  • Exposing properties and populating database columns

    You can expose a property as a database column, and populate the new column by extracting values from the Storage Stream (BLOB or pzPVStream) column using the Property Optimization tool in a development system. You can also use this tool to "expose" values of an embedded property by automatically creating an appropriate Index- class and Declare Index rule.

  • Viewing column population jobs

    You can view the status of column population jobs running in the background that were started by the Property Optimization tool. This tool populates newly exposed database table columns with data values from the BLOB column.

  • Canceling column population jobs

    You can cancel a column population job that was started by the Property Optimizer tool.

Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us