Any tips for speeding up cart loading

Thomas Schmidt

Vote:

Hi,

we are experiencing slow cart loading performance (>100+ms per cart) for carts that actually have items in them. And as we load two carts per request we are already talking 200+ms just for loading carts which is really slowing down performance when a lot of users get on the site.

I can see from the sql server profiler that ecf_Search_ShoppingCart_CustomerAndName is the culprit and the way it is loading data will just slow down even further when more carts and purchase orders are created. We are expecting around 2000-3000 purchase orders per day and of course an even larger amount of carts. We load carts with the CartHelper class.

We are on 8.1.0, in a load balanced setup so caching must work across a load balanced setup (sticky is no-go as that is not really load balancing).

Any tips or places to adjust?

#113941

Dec 02, 2014 8:26

Quan Mai

Vote:

While I don't have any tips for you, I want to say that we have plans to improve Commerce performance, with the separation between cart and order tables in database might improve performance of both. This should happen very soon.

Regards.

#113949

Dec 02, 2014 10:48

K Khan

Vote:

http://world.episerver.com/blogs/Mattias-Lovstrom/Dates/2010/7/Caching-object-EPiServer-is-easier-then-you-probably-think/

Cache your cart/purchase orders, update cart in cache on add/update/remove activities of basket. forgive me if you will not like the idea.

Regads
/K

#114450

Dec 11, 2014 18:18

Thomas Schmidt

Vote:

The problem with caching carts is if you are in a load balanced environment. So request one the user sees 2 items in his cart and on the next request he could potientially see another amount. The CacheManager is not reliable when it comes to invalidation as it uses the event system where events can be missed which would be a disaster on a commerce site.

To make it reliable i would probably have to replace the built in event provider with a custom made Redis pub/sub provider or use the EPiServer Azure one.

Hoping for some performance improvements in the near future :)

#114778

Dec 22, 2014 8:53

Quan Mai

Vote:

With Commerce 8.11 release we improved the loading cart performance to nearly 4 times (To load 1000 orders took 9.5s before, and 2.4s after in our test). I would suggest to upgrade to this or latest version for the performance benefits.

Regards.

#123080

Jun 24, 2015 14:18

Try our conversational search powered by Generative AI!

Any tips for speeding up cart loading