Use Incremental Replication Methods
As mentioned above, long update times are directly correlated to how much data has to be rechecked and replicated. Incremental replication methods can greatly reduce the amount of data processed during the update cycle. Where possible, Adobe recommends using these methods or modifying your database to support an incremental method.
Remove Unused Charts from Dashboards
At the end of the update cycle, Commerce Intelligence performs a cache operation for all charts. A cache stores data so future requests for information can be completed faster. In Commerce Intelligence, this means dashboards load quickly because charts do not need to query data every time they load.
Since Commerce Intelligence only performs cache operations for charts found in a dashboard, removing unused charts from your dashboards decreases your update time. Keep in mind that the same chart might be on multiple dashboards - check with your team to make sure they also removed any unused charts.
Optimize Your Database for Analysis
In addition to reevaluating recheck frequencies, replication methods, and chart usefulness, you can also optimize your database for analysis.
Wrapping Up
If your update time still seems slow even after implementing these recommendations, contact the support team.