JR47162: CMVC 229139 - Remove unnecessary UPDATE SQL statements to the ORDERITEMS table during add to cart and calculation flow

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• During operations such as add-to-cart and calculation, multiple
  SQL UPDATE operations on the ORDERITEMS table are executed,
  typically for each item on the cart. On some cases,
  updates are done even if no data has actually changed. These
  updates can be avoided.
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce users on v7.0 with large carts
  
   PROBLEM ABSTRACT:
   Remove unnecessary UPDATE SQL statements to the ORDERITEMS
  table during add to cart and calculation flow
  
   BUSINESS IMPACT:
   Performance degradation on add-to-cart and calculate commands
  from unnecessary SQL UPDATE operations
  
   RECOMMENDATION:
  

Problem conclusion

• The order and calculation code has been updated to avoid SQL
  UPDATE operations on the ORDERITEMS table if no data has
  actually changed
  
  
   -------------------------------------------------------------
   The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
   http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP