Visual Expert helps review and improve the response time of database and PowerBuilder code (procedures, functions, triggers, queries, objects, methods…).
It is meant for projects using:
To activate the code performance tuning features, Visual Expert must collect usage data in production.
For database code, VE can connect directly to your database, or an authorized staff (e.g. DBA) can activate a collection utility.
For PowerBuilder Tuning, you will have to add a PBL to your application that will generate a trace on each analyzed workstation.
Please follow the procedure corresponding to your configuration:
Once the performance data is accessible, VE must analyze your code again, to combine performance data and source code.
Then, you will be able to answer the following questions:
|Identify slow code and bottlenecks
|Find objects with longest execution time slowing down your PowerBuilder application.
|Improve PowerBuilder app UX
|Find the objects that are executed often and need to be optimized to avoid degrading the user experience.
|Find most frequently executed objects
|Prioritize the objects that need to be improved to optimize the performance of your PowerBuilder app.
|Optimize a chain of calls
|Identify methods that slow down a feature relying on a long chain of calls.
|Review PowerBuilder production metrics
|Identify the slowest pieces of code, the most frequently executed objects, chain of calls with execution time for each node, etc.
|Identify slow DB objects
|Find and sort objects by low response time.
|Optimize a slow DB object
|Break down the response time of a slow object into smaller pieces to identify and remove bottlenecks.
|Optimize slow SQLs
|List the SQL queries accessing a table. Sort them by response time. Review their execution plan to improve them.
|Optimize a business process (database code)
|Analyze the chain of calls behind an application feature: identify slow objects affecting the user experience.
|Review DB production metrics
|Identify the largest tables, the most frequently executed objects, the objects frequently referenced by code, etc.