Kbase P59310: A SQL-92 query runs slower after installing SP7
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/05/2011 |
|
Status: Unverified
SYMPTOM(s):
A large sql-92 query (fetches more than 50 000 records) causes a memory leak
The result set includes array fields
As query execution proceeds, "_sqlsrv2.exe" allocates more and more memory and results in very bad performance
SQL-92 query performance decrease after installing service pack 7
The query runs much slower on 9.1D07 than on 9.1D00
FACT(s) (Environment):
Progress 9.1D
Windows 32 Intel
UNIX
CAUSE:
Bug# 20031208-014
FIX:
Upgrade to 9.1D08 or later.
OR
Upgrade to OpenEdge 10.0A01 or later.