Siebel Tools Reference > Performance Improvement >

Displaying Totals in a List Applet

Whenever data is totaled there are performance implications. It is important to limit the number of records being totaled. For example, totaling the line items in a Quote or Expense report is not resource-consuming; summing the expected revenue for all Opportunities is.

The latter occurs when you generate a chart. However, charts tend not to be generated frequently. Accessing the Opportunities list view for routine searches and data entry is done frequently.

CAUTION:  Never put a sum([MVfield]) in a list column. This requires that a separate query be executed for each record in the list, which is a significant performance issue.


 Siebel Tools Reference, Version 7.5, Rev. A 
 Published: 18 April 2003