Troubleshooting WebSphere Commerce Analyzer: Poor performance

To increase the performance, tune the USRTRAFFIC table.

To tune the USRTRAFFIC table, do the following on the WebSphere Commerce server:

  1. Update the pre-fetch size for USRTRAFFIC. The pre-fetch size is 20 000 by default. The pre-fetch size that you choose depends on the amount of traffic in your store.
    • DB2 Issue the following command from a DB2 command window:
      db2 update keys set PREFETCHSIZE =30000 where TABLENAME = 'ustrtraffic'
    • Oracle Issue the following command from an SQL plus window:
      update keys set PREFETCHSIZE =30000 where TABLENAME = 'ustraffic';
  2. Update the USRTRAFFIC cache size
    1. Open WebSphere Commerce Configuration Manager.
    2. Expand WebSphere Commerce >nodename> Commerce > Instance List >WC_instancename> Log System. The Log System - WC_instancename page displays
    3. In the Activity Log Cache Size field, enter a new cache size. The default size is 20. The cache size you choose depends on the amount the traffic in your store. This cache holds the specified number of data rows in memory before flushing the database. If your site receives a lot of traffic, increase this number to reduce the impact of frequently writing to the database.
    4. Click Apply.
    5. Close the WebSphere Commerce Configuration Manager.
  3. Restart WebSphere Commerce.

Feedback