Bookshelf Home | Contents | Index | Search | PDF |
Performance Tuning Guide > Tuning Siebel Workflow for Performance > Tuning Workflow Processes >
Minimizing Usage of Parameter Search Specification
Although the server component parameter Search Specification (alias SearchSpec) is a feature of Siebel Workflow, it is recommended that you minimize your use of this parameter with workflow processes that are frequently invoked.
Minimizing your use of SearchSpec, especially for frequently invoked processes, improves Workflow engine performance during runtime because the engine does not have to construct the SearchSpec string.
It is important, however, that you do not completely avoid using SearchSpec, because not using this parameter can indicate actions taking place on the current row in some cases, and on all rows in other cases. For specific guidelines, note the following:
- For Siebel operations, minimize usage of SearchSpec.
- For batch process requests, use a SearchSpec that matches as few rows as necessary to get the job done.
Indexing Fields in SearchSpec
If you determine that SearchSpec indeed needs to be used, it is recommended that you make sure all the fields being used are properly indexed. Proper indexing of the fields helps Siebel Workflow and the underlying database to efficiently build queries.
Bookshelf Home | Contents | Index | Search | PDF |
Performance Tuning Guide Published: 24 October 2003 |