About Maximizing Aggregation Performance

The Aggregate action is the most resource-intensive action in the SVP module. To maximize performance, run Aggregate for only select period ranges. Also, use short intervals and run Aggregate only as frequently as your business requirements dictate. For example, if you store sales volume data by week, it is recommended that you run the aggregation at the end of each week and only for the that week.

Note: Running Aggregate for the first time creates a large number of transaction records. It is recommended that you perform this function in an environment that allows optimum performance.

Follow these guidelines to maximize aggregation performance:

• Make sure that the Siebel database is configured according to the Siebel Installation Guide.

• Turn off transaction logging during Aggregate.

• Reextract all mobile clients. For more information, see Siebel Remote and Replication Manager Administration Guide.

For more information about aggregation, see Performing the Initial Aggregation.