As responsible and thoughtful developers we should strive to use configuration techniques with the least negative performance impact. Many performance problems in Siebel CRM projects arise from custom script code.
The following are exemplary reasons for slow application performance during script execution (the list is not complete):
The script interpreter is generally slower than the execution of precompiled C++ code
The script induces complex and long-running SQL statements against the database
Loop constructs can cause the same code to be invoked many times
To overcome these problems we can either resort to administrative or declarative solutions or design our script code to avoid these issues.
To support developers with the latter task, Siebel Tools provides the Script Performance Profiler (available with the ST eScript engine in Siebel 8.1 or higher). The performance profiler allows developers to inspect the performance figures for each line of code early during the...