Kbase P4686: Poor Performance With ESQL/C (SQL89) And A SELECT Statement That Uses MATCHES
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.3D
SYMPTOM(s):
Poor performance with ESQL/C (SQL89) and a SELECT statement that uses MATCHES
CHANGE:
A SQL SELECT statement executes fast when run in the Procedure Editor but runs slowly when run via ESQL/C (SQL89)
CAUSE:
The ESQL/C client is connecting to the database via client/server and is using the MATCHES clause
FIX:
Connect to the database via shared memory and change the SELECT statement so that it uses equality comparisons, BEGINS or CONTAINS instead of MATCHES