Kbase P23036: All SQL queries executed via ODBC are slow
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/8/2009 |
|
Status: Verified
SYMPTOM(s):
All SQL queries executed via ODBC are slow
Slower ODBC performance due to ODBC tracing
Bad ODBC performance
Slow results from ODBC queries
All Data Source Names (DSNs) created on the machine are affected
SQL queries executed via JDBC are not affected
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
ODBC Drivers
CAUSE:
The ODBC tracing is turned on which is slowing down the ODBC performance
FIX:
UNIX:
Set Trace=0 in ODBC.INI for each ODBC Data Source used
Windows:
Turn off the ODBC tracing from the Tracing tab in ODBC Data Source Administrator (odbcad32.exe)