Disable unused queries for the shopping cart agenda builder

If the store uses only Management Center to create and update promotions, we can improve promotion performance by disabling unnecessary queries for promotions.

About this task

If the store uses the default ShopcartDrivenAgendaBuilder, we can disable the two SQL queries that search for promotions that are not created with Management Center. These queries exist to access data that is not stored in the CATENCALCD and CATGPCALCD database tables for promotion calculations. If the store creates and updates promotions only with Management Center, all required data is inserted into these tables, and these queries are not required. These two queries are relatively resource expensive, so a performance improvement can be achieved if the queries do not run. To disable the running of those queries:

Procedure

1. Navigate to workspace_dir\WC\xml\PromotionEngineConfiguration\

2. Open WCSPromotionEngineConfig.xml file for editing.

3. Locate the section PromotionExecutionAgendaBuilder and set the FullIndex value to be true. Ensure that the PromotionExecutionAgendaBuilder section resembles the following code:

   <PromotionExecutionAgendaBuilder impl="com.ibm.commerce.marketing.promotion.runtime.ShopcartDrivenAgendaBuilder">
   	<FullIndex>true</FullIndex>
   	<InvocationTemplates>
   	........
   	........
   	........
   	</InvocationTemplates>
   </PromotionExecutionAgendaBuilder>

Related reference
Promotion performance tuning