4GL Performance Tuning

Duration

• 3 Days

Prerequisites

This course is applicable for students who already know and use the 4GL in business applications. This course could be an excellent refresher for students who have experience of Progress (either formal or self-taught) and wish to brush up on how to use that experience to write more efficient code.

Course Description

This course is for developers who are already familiar with the 4GL, and who wish to improve their skill in writing efficient queries and transactions. It also provides techniques for tuning existing 4GL applications including an overview of tools available for tuning purposes.

Topics

This course is aimed at proficient coders. Some refresher topics are covered in the course.

The following topics are covered in this course.

• Selection of data retrieval methods
  • Network Issues
  • Joins
  • Field lists
  • Record cache
• Transaction review
  • What is a transaction
  • Setting scope
  • Locking
• Indexes
  • How indexes work
  • Index Brackets
  • Cross reference listings
  • Index reposition
• Identifying Issues
  • Application Profiler
  • Promon
  • VST

Objectives

The majority of performance problems on database systems are caused by inefficient code causing too many records to be retrieved from the database. The aim of this course is to show developers how Progress retrieves and updates records and to help ensure they do so as efficiently as possible in production applications.

This course will give developers a complete understanding of indexing rules, record retrieval and should result in their being able to produce faster applications with less issues caused by system growth.

Applicable Progress Versions

The course is taught using Progress version 9, but developers using all versions will benefit. The instructor will highlight any version specific information.

Delivery

• Instructor Led