Identify the Slowest Pieces of Code

Highest Execution Time:

Goal : Identify the slowest procedures, functions or triggers executed.

  1. Select the root of the procedures, functions or triggers
  2. Click "Highest execution time", from the ribbon or the navigation bar
  3. The slowest procedures are listed, based on their average execution time.

find highest execution time with visual expert

This feature comes with 2 parameters to let you customize it (click the small wrench on the right to set them):

  • Number of procedures displayed in the result (20 by default)
  • Minimum execution time, to show only procedures with a significant response time

Customize Visual Expert execution time results

Total Execution Time:

The previous feature (Highest Execution Time) lets you identify the slowest functions, but a slow response time is not necessarily critical if the corresponding functions are rarely used.

To properly assess the criticality of this problem, you must take into account how frequently each function is actually executed:

The feature "Total Execution Time" calculates the total execution time for each procedure, function or trigger, by calculating the Average execution time x Number of times it is executed.

Total Execution time of Database code

This feature comes with 2 parameters to let you customize the result (click the small wrench on the right to set them):

  • Number of functions displayed in the result (20 by default)
  • Minimum execution time, to view only functions with a significant response time

DB Code Total Execution Time: Customize the results with Parameters