WebSphere Commerce EnterpriseWebSphere Commerce Professional

Workspaces performance tuning

Workspaces use of database views instead of tables to retrieve data. Retrieval of underlying data might be more time-consuming because of the complexity of SQL statements that are used in workspace view definitions. Data retrieval from a single workspace view is unlikely to have a significant a performance impact. However, joining (inner or outer join) multiple workspace views can decrease performance.
  1. To alleviate potential performance degradations, apply the following interim fixes:
  2. Run the following command:
  3. Restart the DB2 database manager for the settings to take effect.