Assortments performance issue in Prod

Nuno Aguiar

Posted on 13/04/2022 16:27:00

Hi,

We have a project with a lot of assortments. Currently there are 5000, but we may end up having just 900. The reason for so many assortments is that the customer has 2 main assortments (public + US West coast customer AND East coast customers) and then some customers will have their own assortments.

We can't move away from Assortments, and what we're seeing are 2 things:

When it needs to cache the assortments (i.e. when cache is invalid and/or on first page load) it's doing 1 database call for each record
I am attaching the homepage with "debug=true" in the request where you can tell the hundreds of individual sql queries - one for each assortment (this was taken with <900 assortments)
https://www.screencast.com/t/MdsuU0ktA
Can this be optimized and only do 1 database call? We'd expect performance to be better in the end
Due to the number of assortments, it's noticeable when a request is actually doing the db requests to cache the assortments. Since cache expires after 10min, we're constantly experiencing this.
How could this be improved too?

This is impacting a live website and the attached is from our UAT site running in 9.13.3 (now updated to 9.13.4)

Best Regards,

Nuno Aguiar

UatHomepage.zip

Replies

Nuno Aguiar

Posted on 19/04/2022 19:02:30

bump

I really need some sort of update or acknowledgment on this

Anders Ebdrup

Posted on 19/04/2022 19:19:44

We see this behaviour as well which are slowing down performance on at least two of our solutions so a better approach will be great!

Adrian Ursu

Posted on 19/04/2022 19:32:30

So do we

Nicolai Pedersen

Posted on 20/04/2022 08:35:12

We have created #7464 to look into performance improvements. A developer has been assigned and started to look into it.

Nuno Aguiar

Posted on 20/04/2022 10:55:14

Perfect, thank you Nicolai. Looking forward for the results

Vladimir Shushunov

Posted on 20/04/2022 11:04:09

Hi!
Yep, a developer is looking and had found few potential problems already.

For now, probably it has sense to increase 'Repeat interval' for the scheduled task 'Build Ecommerce Assortment Items' - at least until a fix.

Best regards,

Vladimir

Nuno Aguiar

Posted on 20/04/2022 11:11:17

Hi Vladimir,

I just looked into our most problematic site (the one with thousands of assortments) and the scheduled task is set to rebuild every 1h. I will work with the customer and team to increase this, but we still see the issue every 10 min, so the problem is not only from the actions performed by rebuilding the assorments.

I just wanted to make that clear.

Best Regards,

Nuno Aguiar

Vladimir Shushunov

Posted on 21/04/2022 03:06:22

Hi Nuno,
I found a place in code whiсh causes excessive cache flushes - and now fixing it. So in nearest hotfix performance will be improved.

Regarding 10 min interval, I found that 'Data integration' tasks also could cause Assortments rebuilding (on import).
All scheduling activity is logged - so we can easy check this assumption - look please last log files in the folder: {\System\Log\ScheduledTasks}.

Best regards,
Vladimir

Nuno Aguiar

Posted on 26/04/2022 17:09:57

Hi Vladimir,

I can see there has been some progress on this. I am assuming this will be delivered in 9.13.6.

Am I accurate to expect that to be released on Thursday?

Best Regards,

Nuno Aguiar

Vladimir Shushunov

Posted on 27/04/2022 07:45:19

Hi Nuno,

The fix is tested on 9.13 branch now.
I almost sure it will be released on Thursday:)

Best regards,
Vladimir

Nicolai Pedersen

Posted on 27/04/2022 08:59:45

I believe that it is in Dynamicweb.Ecommerce as of 6 minutes ago:

https://www.nuget.org/packages/Dynamicweb.Ecommerce/

Nuno Aguiar

Posted on 27/04/2022 10:06:11

Hi,

Thank you Vladimir and Nicolai. We'll be putting this to the test. I did peek into the code changes and they sound really promising.

Best Regards,

Nuno Aguiar

You must be logged in to post in the forum

Developer forum

Assortments performance issue in Prod

Replies