Topic
8 replies Latest Post - ‏2012-11-26T19:57:54Z by ApoorvaKhatri
SystemAdmin
SystemAdmin
8614 Posts
ACCEPTED ANSWER

Pinned topic Performance issue with large shopping cart (50+ items in the cart)

‏2011-07-31T12:28:32Z |
Is there any way to resolve the slow performance issue with large shopping cart (50+ items)?

Also is there any specific agenda or sequence builder when only promo codes are used as part of promotions and the promotion is an order level promotion.
Updated on 2012-11-26T19:57:54Z at 2012-11-26T19:57:54Z by ApoorvaKhatri
  • Asger_Jensen
    Asger_Jensen
    154 Posts
    ACCEPTED ANSWER

    Re: Performance issue with large shopping cart (50+ items in the cart)

    ‏2011-08-02T07:58:27Z  in response to SystemAdmin
    Does your store have alot of promotions? If so, that can slow things down quite a bit. Try setting the minsize and maxsize of the cache specifications in PromotionEngineConfiguration.xml to the same value (the high one).
    Also, are you caching the shop cart display? Otherwise it will be doing alot of work looking up product titles and prices again and again, especially if your shop does not use the minibasket to keep people on the category page while shopping.
  • borenst
    borenst
    99 Posts
    ACCEPTED ANSWER

    Re: Performance issue with large shopping cart (50+ items in the cart)

    ‏2011-08-06T22:22:32Z  in response to SystemAdmin
    If all your promotions use promotion codes, then try the CodeDrivenAgendaBuilder.

    Howard
  • StevenGodfrey
    StevenGodfrey
    1 Post
    ACCEPTED ANSWER

    Re: Performance issue with large shopping cart (50+ items in the cart)

    ‏2011-08-10T17:59:06Z  in response to SystemAdmin
    Also make sure you've enabled all the large cart performance improvements:
    http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.developer.doc/concepts/coslscsov.htm
    http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.developer.doc/tasks/toslscsenabledisable.htm
    • ApoorvaKhatri
      ApoorvaKhatri
      14 Posts
      ACCEPTED ANSWER

      Re: Performance issue with large shopping cart (50+ items in the cart)

      ‏2012-11-25T19:25:43Z  in response to StevenGodfrey
      Hi,

      Is there a way to limit size of the cart? Let's say 50?

      Apoorva.
      • KiranYayavaram
        KiranYayavaram
        45 Posts
        ACCEPTED ANSWER

        Re: Performance issue with large shopping cart (50+ items in the cart)

        ‏2012-11-25T22:07:16Z  in response to ApoorvaKhatri
        Look for Size property under ShoppingCartThreshold .
        Refer this article for more info...

        http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.admin.doc/tasks/toscfgbounds.ht
        • KiranYayavaram
          KiranYayavaram
          45 Posts
          ACCEPTED ANSWER

          Re: Performance issue with large shopping cart (50+ items in the cart)

          ‏2012-11-25T22:10:37Z  in response to KiranYayavaram
          Change in

          xml/config/component-id/wc-admin-component.xml

          Updating the link ....
          http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.admin.doc/tasks/toscfgbounds.htm
          • ApoorvaKhatri
            ApoorvaKhatri
            14 Posts
            ACCEPTED ANSWER

            Re: Performance issue with large shopping cart (50+ items in the cart)

            ‏2012-11-26T19:57:54Z  in response to KiranYayavaram
            Thank you Kiran, very useful!
  • Raj.S
    Raj.S
    513 Posts
    ACCEPTED ANSWER

    Re: Performance issue with large shopping cart (50+ items in the cart)

    ‏2012-11-26T12:36:03Z  in response to SystemAdmin
    Please monitor the performance of PromotionEngineOrderCalculateCmdImpl. Try to reduce the redundant invocations of OrderCalculate (if any). If your database is Oracle, also monitor the table PX_PROMOARG for any locks (APAR SE49279 can help avoiding the db locks). As already suggested by Asger, try changing the InitialCacheSIze and MaximumCacheSize of the cache objects in WCSPromotionEngine.xml. But make sure you do not make the cache size too high, which would rather degrade your JVM performace.

    Also, try to reduce the number of promotions if the active promotion count is too high. If there are too many catentry promotions which provide X% OFF or $X OFF, try to define the OfferPrice instead of a promotion (if acceptible by your Business).

    Regards,
    Raj