Kbase P103239: Bad performance occurs with MS SQL Server DataServer when using -fldisable startup paramater with FI
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/07/2005 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
Progress 9.x
MS SQL Server DataServer
SYMPTOM(s):
Bad performances when running a FOR EACH query against MS SQL Server
Progress session is started with the -fldisable startup parameter
The query contains the FIELDS list option
Removing the FIELDS option in the query improves performances
When not using the -fldisable startup parameters improves performances
CAUSE:
This is a known issue being investigated by Development.
When starting a Progress session with the -fldisable parameter, a FOR EACH query with the FIELDS option sends a couple of SQL queries to the MS SQL Server database instead of only 1 query.
FIX:
There are 2 ways to work around this problem:
1- Do not specify the -fldisable startup parameter
OR
2- Do not use the FIELDS option in the FOR EACH query