Support Center
  • English
  • Japanese
  • French
  • Spanish
  • Deutsch
  • Russian
Visual Expert
Explore, Analyze & Document your Code
  • Features
    • Visual Expert for Oracle
    • Visual Expert for PowerBuilder
    • Visual Expert for SQL Server
  • Price
  • Documentation
  • Support
    • Videos
    • System Requirements
    • Contact the Support
    • Release History
    • Visual Expert Code Inspection Rules
  • News
  • Company
    • About
      • Company Profile
      • Customers
      • Contact Us
      Other Products
      • Visual Guard
      • Ultimate Suite for PowerBuilder
      • Enable for PowerBuilder
      • PowerDesigner
      • SQL Anywhere
      • PB Protect
      Community Actions
      • Novalys PowerBuilder Newsletter
      • Novalys PowerBuilder Survey
      • PowerBuilderTV
      • PowerBuilderTV News
  • Download
    • Visual Expert for Oracle
    • Visual Expert for PowerBuilder
    • Visual Expert for SQL Server
  1. Home 
  2. Doc 
  3. Code Review 

Code Review

Continuous Code Inspection

  • Key Concepts of Code Inspection
  • What to Expect from Visual Expert?
  • Code Inspection Dashboard
  • Using Code Inspection in VE Web
  • Graph Tooltips to Guide through Code Inspection
  • Export the Code Inspection Dashboard
  • Generate Code Inspection Report in JUNIT/JSON formats
  • Inspect a Specific Object or Library
  • List of Inspection Rules
  • List of Code Inspection Profiles
  • Code Inspection Settings
  • Code Inspection Profiles
  • Security Vulnerabilities
  • Code Injection Attacks
  • Getting Started
    • How to Inspect SQL Server Code
    • How to Inspect Oracle Code
    • How to Inspect PowerBuilder Code
  • Visual Expert Plugin for Jenkins
  • Add a Jenkins job with command line
  • Add a Jenkins job with VE Plugin

Code Review

  • Generate a code review report
  • Sample Reports
    • SQL Server Code Review Report,
      Oracle Code Review Report,
      PB Code Review Report,
      PB+SQL Server Code Review Report,
      PB + PL/SQL Code Review Report
  • Number of lines of code
  • Number of Objects
  • Large Scripts and Functions
  • Empty Scripts and Functions
  • Non-inherited PowerBuilder Objects

Naming Conventions

  • Check Naming Conventions
    • For Oracle & PL/SQL Objects 
    • For SQL Server & T-SQL Objects
    • For PowerBuilder & PowerScript
  • Verify DB Object Naming Conventions
  • Unnamed PowerBuilder Controls
  • Missing Comments

Code Cleanup

  • Remove Dead Code
  • Remove Duplicate Code
  • Remove Duplicate Functions
  • Remove Deprecated Features
  • List of Oracle Deprecated & Desupported Features

Set up Performance Analysis

  • Setup for PowerBuilder Apps
  • Setup for Oracle (Direct Access to the DB)
  • Setup for Oracle (No Access to the DB)
  • Setup for SQL Server (Direct Access to the DB)
  • Setup for SQL Server (No Access to the DB)

Database Performance Tuning

  • Largest Tables by Row Count
  • Largest Tables by Volume of Data
  • Most Frequently Executed Objects at Runtime
  • Most Referenced Objects by Code
  • Table Information (Size & Row Count)
  • Identify Slow Database Objects
  • Get a Query Execution Plan (SQL Server)
  • Get a Query Execution Plan (Oracle)
  • Optimize a Slow DB Object
  • Optimize a Business Process
  • Optimize Slow SQL Queries
  • Find Missing Indexes

PowerBuilder Performance Tuning

  • Find Slow Code and Bottlenecks in your PB App (Slowest Code)
  • Improve the User Experience of your PB App (Cumulated Execution Time)
  • Focus on frequently used objects (Most Used Objects)
  • Optimize a Chain of calls (Call Graph Execution Time)
  • PowerBuilder Code Profiling

Use Cases

  • Perform a General Review of a PowerBuilder application
  • Improve a Specific Feature in a PowerBuilder application

PowerBuilder Code Rules

  • Secure your Encryptions
  • Secure your OS Encryptions
  • Improve your Coding Practice
  • Index
  • Configuration & Support
  • Create your Project
  • Cross References
  • Code Review
  • Code Documentation
  • Performance Tuning
  • Visual Expert Web
  • More features
  • Use Cases
  • Beta
    Visual Expert.AI
  • Download Visual Expert

Visual Expert Featured Resources

How to

  • Inspect your Code
  • Document your code
  • Analyze Several Databases at the same time
  • Analyze multiple PB applications
  • How to Setup a Cross-language Analysis (PowerBuilder + SQL Server Code)

  • Generate a CRUD Matrix
  • Find PowerBuilder calls to Web Services
  • Generate Diagrams from Your Code
  • NVO declared in PB Objects and Methods
  • Analyze DB Code Performance
  • New Code Analyzer for SQL Server T-SQL

Videos

  • Find References to a Column in PB code (Video)
  • Find references to a column in PL/SQL (Video)
  • Review CRUD operations in your Code (Video)
Novalys

Novalys is an international Software Vendor, founded in 1998, privately held, with subsidiaries and distributors in North America, Europe, South America, Middle East and Asia. We provide development team with powerful solutions to develop and maintain successful applications. Learn More

  • Support
  • Privacy
  • Site Map

Novalys Websites

blog-thumb
Novalys Corporate Website

Learn More


blog-thumb
PowerBuilderTV

PowerBuilder Webcasts


blog-thumb
PBTV News

PowerBuilder Tools, News, Services and Webcasts

More

Find Us

  • 41/43 rue Paul Bert
  • 92100 Boulogne Billancourt France
  • sales@novalys.net

Copyright © 2025 Novalys. All Rights Reserved