Oracle APEX application is blazingly fast. Its' performance can be negatively effected by poorly written queries. To optimize application performance, you can use few substitution strings to see elapsed time for rendering each region in a page. This helps in pin pointing long running regions and tuning queries behind them.
- #TIMING# shows elapsed time in seconds used when rendering a region. This includes time to render region items as well.
- #TOTAL_ROWS# displays total number of rows retrieved by SQL query
- #ROWS_FETCHED# shows the number of rows fetched by APEX. It shows page size if total total number of rows is greater than pagination rows.
- #FIRST_ROW_FETCHED# and #LAST_ROW_FETCHED# display the range of rows displayed. It depends on number of rows defined for pagination.
- Edit region Search Person. In Footer, enter the message Fetched #ROWS_FETCHED# rows of #TOTAL_ROWS# in #TIMING# seconds
- Apply changes. Run the application
Comments
RSS feed for comments to this post