Bookshelf Home | Contents | Index | Search | PDF

Siebel Business Process Designer Administration Guide for Financial Services > 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:

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

Bookshelf Home | Contents | Index | Search | PDF