Configuring a Multivalue Group Business Component

You can use the Maximum Cursor Size property and the PreFetch Size property with a multivalue group business component. These properties are available only with a DB2 UDB database. The following items affect the number of rows that Siebel CRM returns for the first operation that a multivalue group business component performs:

• If the multivalue group business component uses aggregation, then it reads every record. The sum function and the count function are examples of aggregation.

• A multivalue group business component attempts to make the primary record the current record. Siebel CRM loads records until it finds the primary record. For example, if the primary record is the 4,000th record, then it loads 4,000 records. To prevent this configuration, you can use a detail view instead of a multivalue group. For example, you can use the Contact - Address detail view with the Contact in the applet at the beginning of the view and a list of addresses in the following applet.