Troubleshooting WebSphere Commerce Analyzer: Poor performance

Troubleshooting WebSphere Commerce Analyzer: Poor performance

If WebSphere Commerce has poor performance after turning on the USRTRAFFIC event listener, you can use the following technique to increase the performance.

To tune the USRTRAFFIC table, complete the following tasks 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.
Connect to the WebSphere Commerce database, and then issue the following command from a DB2 command window:
db2 update keys set PREFETCHSIZE = 30000  where TABLENAME = 'usrtraffic'
Issue the following command against the WebSphere Commerce database from an SQL plus window:
update keys set PREFETCHSIZE = 30000  where TABLENAME = 'usrtraffic';

Update the USRTRAFFIC cache size

Open WebSphere Commerce Configuration Manager.
Expand WebSphere Commerce >node_name> Commerce > Instance List >WC_instance> Log System. The Log System - WC_instance 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.