CHAPTeR 9 DXP PeRfORMANCe OPTIMIzATION • Record the time for various steps in the business process and transaction: • For critical business process and time-consuming transactions, record the time taken for each step in the process. • Repeat this step by increasing the load. • Profiling the components: • Profiling presentation layer: • In addition to layer-wise performance metrics, use developer tools to profile the web pages. • Web page profiling provides useful metrics such as categorized asset size, categorized asset load time, and such. • Profile the server-side components to understand the memory consumed by server side components: • Business components performance analysis • API and call tracing analysis • Database call performance analysis • Enterprise integration performance analysis • Profile the database by understanding the execution plan for the queries: • Review the data model to see if it is properly utilized. • Explore the possibilities of using lookup tables and snapshot tables to prepare/cache the data for frequently accessed queries and for static values. 249