Siebel Business Process Designer Administration Guide > Performance Tuning > Tuning of Workflow Processes >

Minimizing Usage of SearchSpec

Although SearchSpec is a feature of Workflow, it is recommended that you minimize your use of this feature with workflow processes that are invoked very frequently. 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 to note, however, that you should not completely avoid using SearchSpec, because using no SearchSpec 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:

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 Workflow and the underlying database to efficiently build queries.

 Siebel Business Process Designer Administration Guide 
 Published: 29 May 2003