Visual Expert can identify the most frequently executed objects in the database.
This helps PowerBuilder, Oracle, and SQL Server developers prioritize their work and efficiently optimize their code.
How to find frequently executed objects with Visual Expert?
- First, you need to activate performance monitoring features within Visual Expert. (See this tutorial)
- Then, run your code analysis again.
- This feature will appear in the Performance section of the navigation bar after selecting the root of procedures, functions, or triggers:
Adjust the number of objects you want to display by clicking the ‘wrench’ icon:
In this example, Visual Expert will display the 5 most frequently executed procedures.
Read the tutorial on how to optimize code performances for more information.