Marketing statistics considerations
Operational marketing statistics are gathered and stored in the database by the RaiseECEvent scheduled job that is run by the Scheduler at a set interval. By default, this job runs every 5 minutes. To decrease the frequency of this job to reduce any performance impact it might have, you can increase the interval between the jobs.
To change the time interval for the job, run the following SQL statement:
UPDATE SCHCONFIG
SET SCCINTERVAL = 1800
WHERE SCCPATHINFO = 'RaiseECEvent'
The SCCINTERVAL value defines the length of time, in seconds, before the job is restarted.
Note: If you are using Management Center for marketing, the time interval
value is also configured in the wc-admin-component.xml file
for the marketing component. You must update the interval value in
that file to match the interval value you specified in the SQL statement.
In the wc-admin-component.xml file, look for
the following property:
<_config:property name="orderSubmitProcessingFrequency" value="1800"/>
For
instructions on updating the wc-admin-component.xml file,
see Changing
properties in the marketing component configuration file.