Kbase P97157: Bad performance for a PreparedStatement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
OpenEdge 10.0B
SYMPTOM(s):
Bad performance for a PreparedStatement
UPDATE INDEX STATISTICS run earlier
Query runs 10 times slower after UPDATE INDEX STATISTICS
CAUSE:
This is a known issue being investigated by development.
"UPDATE INDEX STATISTICS" updates data within the sysprogress.sysidxstat table; the query plan is different due to that data.
CAUSE:
A workaround is to remove the "update index statistics" information with the statement:
delete from sysprogress.sysidxstat;
If your application allows you to control what is sent to the SQL Server, then a solution is the 4 following steps:
1. Have a none autocommit connection
2. Run "delete from sysprogress.sysidxstat"
3. Execute the "preparedStatement"
4. Disconnect