Articles & Content

Archives

IDS 10.0 Performance Tuning (K01)

Topic: 2005 NA

Subtopic: Informix



DATE: 2005-05-23 (10:20 AM - 11:30 AM)
SPEAKERS: Mark Scranton (IBM)

This presentation will cover the "new" performance tuning considerations for IDS 10.0, building on architectural changes that occurred in IDS 9.4. The most significant performance features in version 10.0 will be covered; Configurable Page Sizes, Memory Allocation for Non-PDQ Queries; Dynamic OPTCOMPIND; External Optimizer Directives. References will be made to other features that should considered when tuning IDS 10.0 - the most significant IDS release since 1996.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

The Changing Industry - how is that changing tuning?

IDS 9.4 Architectural Changes - the foundation for IDS 10.0

Configurable Pages Sizes/Multiple Buffer Pools - many, many benefits

Memory Allocation for non-PDQ Queries - helping all queries run well.

Dynamic OPTCOMPIND/External Optimizer Directives - influencing query behavior



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.