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.
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 (OpenROAD, IngresABF), 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