Optimizing Actian X Performance  (Instructor-led)

Optimizing Actian X Performance (Instructor-led)

The focus for this paid for instructor-led course is on discussions regarding factors that affect performance in Actian X. A wide range of topics are covered ranging from database and application design to installation tuning.

rate limit

Code not recognized.

About this course

Instructor-led Yes
Duration 5 days
Course charge Yes.  Please email the Actian Education team to discuss further
Product version Actian X 11.x
Course code Performance

At the end of this course you will be able to:

  • Understand the performance issues associated with Actian X
  • Diagnose, prevent and remove performance problems and build more efficient database systems

Course Style

The focus of this course is on discussions regarding factors that affect performance in Actian X. A wide range of topics are covered ranging from database and application design to installation tuning.

Who Should Attend

This course is for Database Designers, Database, and System Administrators and Developers responsible for the implementation of high performance Actian X systems.

Prerequisites

Managing Actian X Installations and Databases (IngresDBM) or OpenROAD/ABF Application Development and Maintenance (OpenROADIngresABF), plus several months experience.

Key Topics

  • Performance diagnostic strategy
  • Storage structures, Secondary indexes and Compression
  • Data loading
  • Physical database design: Selecting keys, Controlled redundancy, Horizontal and vertical fragmentation
  • Optimization: Statistics, Simple Benchmarks, Query performance diagnostics, Query execution plans, Query flattening
  • Transaction design: Locking and concurrency, Relational thinking, Cursor performance, Select loops, Repeated queries
  • Database procedures and rules
  • Data validation
  • Temporary table management
  • Installation tuning: Logging System, Locking System, DBMS Server tuning, eg. DMF, QSF
  • Installation tuning (CBF) tools
  • Interactive Performance Monitor (IPM) tools
  • Actian X Management Architecture (IMA) tools: IMP, Visual DBA, SQL scripts
  • Operating system considerations

About this course

Instructor-led Yes
Duration 5 days
Course charge Yes.  Please email the Actian Education team to discuss further
Product version Actian X 11.x
Course code Performance

At the end of this course you will be able to:

  • Understand the performance issues associated with Actian X
  • Diagnose, prevent and remove performance problems and build more efficient database systems

Course Style

The focus of this course is on discussions regarding factors that affect performance in Actian X. A wide range of topics are covered ranging from database and application design to installation tuning.

Who Should Attend

This course is for Database Designers, Database, and System Administrators and Developers responsible for the implementation of high performance Actian X systems.

Prerequisites

Managing Actian X Installations and Databases (IngresDBM) or OpenROAD/ABF Application Development and Maintenance (OpenROADIngresABF), plus several months experience.

Key Topics

  • Performance diagnostic strategy
  • Storage structures, Secondary indexes and Compression
  • Data loading
  • Physical database design: Selecting keys, Controlled redundancy, Horizontal and vertical fragmentation
  • Optimization: Statistics, Simple Benchmarks, Query performance diagnostics, Query execution plans, Query flattening
  • Transaction design: Locking and concurrency, Relational thinking, Cursor performance, Select loops, Repeated queries
  • Database procedures and rules
  • Data validation
  • Temporary table management
  • Installation tuning: Logging System, Locking System, DBMS Server tuning, eg. DMF, QSF
  • Installation tuning (CBF) tools
  • Interactive Performance Monitor (IPM) tools
  • Actian X Management Architecture (IMA) tools: IMP, Visual DBA, SQL scripts
  • Operating system considerations