Hi guys,
Working on a project containing multiple shops and area's we're encountering long rendering times for pages containing either an Ecom or CartV2 module. When calling a page a user has to wait for a long time before getting respons from the server, this can take as long as 12-18 seconds per request! It's clear our customer isn't very happy with these kind of request times but we can't find the best way to fix this issue.
First of all it's hard to find good documentation on caching in Dynamicweb. Using the searchbox in this portal certainly isn't of any help. Secondly, running dotTrace we get insights in the page rendering and it looks like we get some very long queries concerning counting products (for example, Dynamicweb.eCommerce.Products.Product.GetProductsCountByGroups() takes more than 4 seconds to complete, but it's called at least twio times where the second time the delay is another two seconds).
Is there any way in fixing these problems, in caching more information or some other way to make the application more responsive to requests?
Cheers,
Tom