Code Review

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