Minimize the Number of Records in the Forecasting Table

Use a restrictive Auto Forecast Search Spec. Do not include product or revenue line item details for an opportunity unless they are needed. Only include opportunities that are committed or that meet some minimal criteria.

Consider implementing a process that batches up the revenue records or summarizes the information in the revenues table before the creation of the forecast itself. For example, a customer with hundreds of thousands of detailed revenue line items wants to summarize the related revenue line items into higher level revenue line items before creating the weekly or monthly forecast. This keeps unnecessary detail out of the forecast.