Developer forum

Forum » Ecommerce - Standard features » Discounts and query picker is killing the performance

Discounts and query picker is killing the performance

E-mail notifications
Kim Søjborg Pedersen
Reply
Posted on 29/06/2018 11:37:18

Hi, I'm just playing around with the discounts and picking products with the query feature and ran into a performance problem.

Here is some facts about my setup:
There is 3000 products total in the eCommerce
Query 1 (4) The query is picking 4 products.
Query 2 (1000) The query is picking 1000 products
DW 9.3.12

Showing the products from a group with about (1300 products) on at paragraph with a paging size on 25 products. 

Loadtimes:

With no active discounts (1.13s) 

1 active discount with 4 products selected with the product picker (1.11s)

1 active discount with query 1 (3.96s)

1 active discount with query 2 (36s)

Regards
Kim

 

 


Replies

 
Nicolai Pedersen
Posted on 29/06/2018 12:00:29
Reply

Hi Kim

Try it again on 9.4 - a LOT of things has been rewritten, and we will not start debugging on 9.3

BR Nicolai

 
Kim Søjborg Pedersen
Posted on 05/07/2018 16:13:42
Reply

Hi Nicolai

Now I have upgraded and testet in 9.4.15 and the result is the same.

Regards
Kim

 
Kim Søjborg Pedersen
Posted on 05/07/2018 21:09:53
Reply

Loadtimes on 9.4.15 

No Discount: 0.7 s

Query selecting 100 products: 4.6 s

Query selecting 1000 products: 36 s

 
Nicolai Pedersen
Posted on 06/07/2018 16:26:01
Reply

Can I get a screen dump of your setup of the discount?

 
Kim Søjborg Pedersen
Posted on 30/07/2018 09:47:51
Reply

Hi Nicolai
Just returned from vacation :) The setup is attached

Regards
Kim

2018-07-30_0945.png
 
Kim Søjborg Pedersen
Posted on 05/10/2018 12:03:51
Reply

Hi Nicolai
Any news or comment about this?

I just tried on a partner install with  9.5.2 and Rapido 3 with same result.

Regards
Kim

 
Nicolai Pedersen
Posted on 05/10/2018 15:00:38
Reply

Hi Kim

We need a link to the solution with the query and the discount so we can check it out.

 
Kim Søjborg Pedersen
Posted on 08/10/2018 18:10:41
Reply

Hi Nicolai

It is http://akqa.dw9demo.dynamicweb-cms.com/products/bikes/road-bikes where we have a sales query on roadbikes. It takes 1.5 min to load

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Posted on 11/10/2018 07:17:48
Reply

Hi all,

It seems to be related to cache not enabled with the condition for discount calculation of type 'Order discount'. New TFS 56245 has been created against the issue. Thanks.

PS: The solution mentioned by the link above already uses discount type of 'Discount' enabled has the same condition with quite well performance and can probably be used as temporarry workaround not recomended in fact.   

BR, Oleg QA

 

 
Kim Søjborg Pedersen
Posted on 11/10/2018 08:05:49
Reply

Hi Oleg

I'm not sure I understand the PS part of your answer, and I can see the discount you created is not based on a query.

Can you confirm the you see the performance issue with querybased discount and it will be fixed?

Regards

Kim

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Posted on 11/10/2018 08:40:37
Reply

Hi,

pls, find attachment related to settings of discount on our solution. I see the performance gets down (has hude delay your have describe before) with the order discount enabled only (I created this to test) . 

BR, Oleg QA

2018-10-11_1635.png 2018-10-11_1636.png
 
Kim Søjborg Pedersen
Posted on 11/10/2018 09:08:56
Reply

Hi Oleg

Okay if you look into the problem with "Discounts" I'm very happy :)

Can you tell why there are both "Discount" and "Order discounts", for me they seem almost the same. The advice I've got is always to use "Discounts" because it has more options

BR.
Kim

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Posted on 12/10/2018 02:44:29
Reply
This post has been marked as an answer

HI,

'Discounts' part has stuff of old type could be come with old DW versions and not recomended to use nowadays, I've already posted link to DW manual above, please have a look at it for details. So, the issue will be fixed for 'Order discounts' only.

BR, Oleg QA 

Votes for this answer: 1
 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 09/01/2019 15:45:33
Reply

Hi Kim

The problem with Cache on discount included/excluded queries has now been resolved in Dynamicweb hotfixversion 9.5.7

To upgrade please choose this version from download:

http://doc.dynamicweb.com/releases-and-downloads/releases

Let me know if you need any more help regarding this

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 

You must be logged in to post in the forum