StatsV2 and Recommendations

Hi DW

We have a client running DW 9.9.5 and are experiencing some performance issues on the site. One of the issues seems to be related to the product recommendation engine (e.g. WhatAboutTheseProducts and CustomersWhoSawThisAlsoSaw) getting the data from the StatsV2 table. Below is a screenshot of the stacktrace and the time consumed (usually between 1,5 to 3 sec.).

The StatsV2 tables in this solution are quite large, and some of the older entries could be purged from the tables, but considering the old statistics being deprecated, we want to implement a solution to this, that is futureproof.

Is there any smarter implementation of the recommendation engine in newer DW version, and if not what is the recommended solution for continuing to use the recommendation engine without getting this performance hit.

BR Chris

Hi Chris

Yes - there is the index based recommendations that was introduced in 9.10. It does not rely on any tracking data - only purchase history.

https://doc.dynamicweb.com/documentation-9/ecommerce/other/product-recommendations#11609

They are a little more difficult to setup - but they are much much faster.

These recommendations can be done using all sorts of metrics because they are using the index. But they do not contain what other people saw - only what they bought.

You can use the new approach to find other popular products in the same color, of the same type, in the same group or whatever you require. The best way is to load the recommendations async.

Until you have that feature avail, cleaning the database and setup a cleaning job to keep the table small, is a temp workaround. See how to setup database table cleanup here:

https://doc.dynamicweb.com/documentation-9/platform/platform-tools/logs#5585

Developer forum

StatsV2 and Recommendations

Replies