Kbase P25842: MSS DataServer uses UPPER function and impacts performance.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/05/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1B
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
MSS DataServer uses UPPER function and impacts performance.
Protomss was performed not using shadow columns.
The fields were marked as case insensitive to match the Progress fields.
If doing a schema pull only, the fields are not changed.
The problem also appears if a pull is done then the ADJUST SCHEMA utilities is used.
CAUSE:
The DataServer uses the UPPER function, which impacts performance.
CAUSE:
Bug# 20010329-011
FIX:
The bug is fixed in the patch 9.1B13 on Win32 platform.