Performance problem with LF having Select and Omitt Levels
Page 1 of 1
Performance problem with LF having Select and Omitt Levels
Performance problem with LF having Select and Omitt Levels
Most shops that are moving from record level access (RLA) to SQL data access still have logical files built using DDS that have select/omit logic
The problem:
This is a problem that the SQL Query Engine (SQE) cannot process SOL logical files by design and forces the SQL to be executed by the Classic Query engine (CQE).
How to override this problem:
This can be averted by changing the QAQQINI file so that SOL logical files are ignored. To do this, change the value of IGNORE_DERIVED_INDEXES to *YES. This is going to vastly improve our overall SQL performance considerably.
Most shops that are moving from record level access (RLA) to SQL data access still have logical files built using DDS that have select/omit logic
The problem:
This is a problem that the SQL Query Engine (SQE) cannot process SOL logical files by design and forces the SQL to be executed by the Classic Query engine (CQE).
How to override this problem:
This can be averted by changing the QAQQINI file so that SOL logical files are ignored. To do this, change the value of IGNORE_DERIVED_INDEXES to *YES. This is going to vastly improve our overall SQL performance considerably.
Similar topics
» SORTING - DESCEND problem
» Cursor problem - DSPF
» Record lock problem
» You are NOT allowed to use SNDBRKMSG. No problem GO with API QEZSNDMG
» Problem with display - Header area is not displayed
» Cursor problem - DSPF
» Record lock problem
» You are NOT allowed to use SNDBRKMSG. No problem GO with API QEZSNDMG
» Problem with display - Header area is not displayed
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|