Code Performance Analysis [Beta]

VE 2018 brings a new set of features to identify slow pieces of DB code (Oracle or SQL Server) and improve their response times

You can:

Sort functions and procedures by "Average Execution Time".

Sort functions and procedures by "Total Execution Time"

Analyze the performance of a chain of calls

Average Execution Time

Identify the slowest code.

Total Execution Time

Average execution time × Number of executions over a period.

Performance of a chain of calls

Review the performance of objects calling each others in your applications. Improve the response time of a business process.

Identify performance issues

After you identified a slow function, this feature allows to analyze the items composing it, to pinpoint precisely the performance issue

Visual Expert Videos

Watch these short videos to catch a glimpse of Visual Expert powerful features

Visual Expert Key Features

Visual Expert is a must-have solution for the maintenance of your PB and DB code.
Using Visual Expert, developers easily discover and start working on any existing applications.
Understand the code - Identify the modification - Validate the effect of the change - Generate CRUD Matrix - Documentation - and more!

Identify the Consequences of a Change

"If I change this, what is the effect?"

Estimate what you should modify to accomplish a change.
Don't break your application after a change!

If I change this variable, what is the effect on my code?

If I add a parameter to a function, what else is affected?

If a table or column is changed, which code should I update?

Review CRUD operations in your code
(Create, Read, Update, Delete)

Generate a CRUD matrix showing which programs access your data.

For instance, which DW or Procedures Create/Read/Update/Delete which Tables.

Review dependencies between database and PB applications.

Analyze the impact of changing your database Schema, for example changing a table definition or adding an index.

Estimate software complexity and development efforts.

Find out which table is never updated, deleted from multiple places, etc.

Make sure every process has at least one input (R) and one output (CUD).

Explore complex chains of calls

Display Call Trees:
callers and callees for Functions and events.

Explore all possible execution paths.
Drill down in the code, click on referenced methods or variables to see their definitions.

Call trees help evaluate the effects of modifications to your code.

Document your code

Generate documentation from your code

Create reference manuals in HTML.
Update your documentation on a regular basis (scheduled job).
Document the references in your code and navigate between these using hyperlinks.
Share knowledge with teammates.

Get your Free Trial

Use Visual Expert with your Code

Feedback from our clients

Reduces expenses

Using VE's features allows a much quicker turnaround, reduces
expenses and frees up resources for more productive work.

- Project Manager

New York State Department of
Environmental Conservation

Become familiar with a new application in literally a few hours

(The) More you work with Visual Expert - more you understand
how convenient it is. (...) I cannot remember so powerful a tool
that allows a user to become familiar with a new application in
literally a few hours

- Georges Mikhailovsky

Calibre Systems

Novalys is an international Software Vendor, founded in 1998, privately held, with subsidiaries and distributors in North America, Europe, South America, Middle East & Asia.
Visual Expert helps developers discover and work on any existing applications. Understand the code, Identify the modification, Validate the effect of the change with Impact Analysis, Generate Source Code Documentation... Analyze your Code and Database