Developer forum

Forum » Ecommerce - Standard features » Switching Ecom Context Is Slow

Switching Ecom Context Is Slow

Jeppe Jakobsen
Reply

Hello Dynamicweb

I have solution where i'm using two EcomCart Contexts, one called "Cart_1" and "Cart_2". The contets are based upon pre-orders(1) and normalt products(2).  

When i'm using the cart module i can send the parameter "&OrderContext=" with my url to decide which context that i want to access, and do whatever i need. My solution is working with this, but for some reason it is very slow.

I have a cart with about 25+ orderlines(consisting of variants). The template i am using is only standard dw templatetags. Upon adding the "debug=true" parameter to the url, the log reveals some expensive queries to the database. I am not entirely sure why they take so long and how reduce them.

I attached some examples.

I have been using the cart module many times before without seeing these expensive queries, but this is the first time I'm using it with two different contexts. It seemed pretty straightforward, but switching between them 'on the fly' seems to be very expensive.

So any pointers would be very much appreciated.

 

Best regards, Jeppe.  

1.PNG 2.PNG 3.PNG 4.png

Replies

 
Nicolai Pedersen
Reply

Hi Jeppe

Except one of the SQLs they are all fast - should probably not be there, but they are fast. The one taking 640 ms has nothing to do with the cart - it is some statistical information getting queried.

We would need a URL to take a further look at the context and maybe causes.

BR Nicolai

 
Jeppe Jakobsen
Reply

You would need a login and a cart with products to get anything from a url. Can i contact you with the details?

 
Jeppe Jakobsen
Reply

You would need a login and a cart with products to get anything from a url. Can i contact you with the details?

 
Nicolai Pedersen
Reply

You will have to contact the service desk then.

BR Nicolai

 

You must be logged in to post in the forum