Database performance tuning

The database is usually one of the potential areas for bottlenecks that makes HCL Commerce unable to scale and perform well. It is therefore crucial that the database is tuned appropriately for your implementation.

Before you attempt to tune the database, it is important to realize that an HCL Commerce implementation is considered an online Transaction Processing (OLTP) application. You must tune the database for an OLTP application. The following are typical characteristics of an OLTP application:
  • It has frequent insert or update activity.
  • There are a high number of users that are accessing the database.
  • SQL running against the database is quick and relatively simple.