To increase the performance, tune the USRTRAFFIC table.
To tune the USRTRAFFIC table, do the following on the WebSphere Commerce server:
- 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.
- Update the USRTRAFFIC cache size
- Open WebSphere Commerce Configuration Manager.
- Expand WebSphere Commerce >nodename> Commerce > Instance List >WC_instancename> Log System. The Log System - WC_instancename page displays
- 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.
- Click Apply.
- Close the WebSphere Commerce Configuration Manager.
- Restart WebSphere Commerce.