If you are using the SQL Repository, see how multiple requests of the same behavior affect cache usage. The first time your application references database information, the request causes a SQL database operation, but subsequent requests will use the cache. Try to optimize cache usage. Consider the best caching mode to use for each of the item descriptors in your SQL repositories. See the ATG Repository Guide for more information.

When you are testing the system, make sure you think about real-world usage of your data. If your system could potentially have tens of thousands or millions of rows of data, make sure you test that scenario. If you test only against small sets of data, some performance bottlenecks will be masked, because the database can cache the entire dataset into memory.