Bad response times loading products lists with live integration enabled

Johan Ulff

Posted on 14/06/2021 09:09:04

Hi, we have very long loading times when showing product listing pages. I can see in the live integration log file that we have 500+ calls to BC when loading the product listing, and we are just listing 24 products on each page.

It seems that live integration fetches prices for all product variants, even when the option "Include variants in product information request" in live integration settings is not enabled. Cache level is set to Session. Can we in some way minimize the number of calls live integration makes to BC?

The current response times is not acceptable for our customers iand we must solve this ASAP.

Replies

Dmitriy Benyuk

Posted on 14/06/2021 09:24:32

This post has been marked as an answer

Hi Johan,
is your solution availbale on-line so we can look on its setup? Can you provide the url?
If not can you describe what Dynamicweb version and Live integration versions are you using? The Dynamicweb service is used or not?
BR, Dmitrij

Votes for this answer: 1

Johan Ulff

Posted on 14/06/2021 09:29:08

Can we send the URL and login direct to you?

My email is johan.ulff@mindflower.se and my phone is +46 730722531

Dmitriy Benyuk

Posted on 16/06/2021 13:00:12

Hi Johan,
could you uncheck the option "Use product number in price calculation" as a workaround?
Then the reqeusts to BC will be made much more less since your variant products have the same ProductIds as main products.
I can see that you have only 4 products whoose Ids are not a numbers (like PROD*).
We are still looking how to fix this problem in the other way.
BR, Dmitrij

Johan Ulff

Posted on 16/06/2021 14:05:28

I cannot see any real performance difference when doing that. We still have response time>60 seconds for product collections.

You must be logged in to post in the forum

Developer forum

Bad response times loading products lists with live integration enabled

Replies