Database performance tuning
The database is usually one of the potential areas for bottlenecks that makes WebSphere 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 a WebSphere 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.