Code Performance Tuning with Visual Expert

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:

  1. SQL Server databases with Transact-SQL code
  2. Oracle databases with PL/SQL code
  3. PowerBuilder code

Step 1: Configure your Visual Expert Project

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:

  1. Oracle - VE can connect directly to the Database
  2. Oracle - VE CANNOT connect directly to the Database
  3. SQL Server - VE can connect directly to the Database
  4. SQL Server - VE CANNOT connect directly to the Database
  5. Collect PowerBuilder Performance Statistics

Step 2: Review your code

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: 

How to Optimize your PowerBuilder App Performance?

Performance type Purpose
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.


How to Optimize your Database Code Performance?

Performance type Purpose
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.