Performance Considerations

Updating workflow step security with a specific configuration can affect system performance. When adding dynamic security to a step, such as based on a standard or user-defined token, in the Workflow Step window on the Layout tab, product database tables are updated to handle the new configuration.

Migrating a workflow with these types of changes into an instance of the PPM can also affect system performance. Product database tables must be updated to handle the new workflow.

Because of the scope of these database changes, we recommend that you rerun statistics on your PPM database schema. For information about how to collect database statistics on your database, see the Installation and Administration Guide. For help with this procedure, contact your database administrator.