Kbase P134716: SQL: Where are the OpenEdge SQL statements executed?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/29/2008 |
|
Status: Unverified
GOAL:
SQL: Where are the OpenEdge SQL statements executed?
GOAL:
Are the OpenEdge SQL statements executed on the server, the client or both?
GOAL:
Does the execution of SQL read-only statements contribute to the growth of the bi file?
GOAL:
How does the execution of SQL read-only SELECT statements affect the application performance?
GOAL:
What are some of the factors that affect SQL query execution speed and performance?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The analysis and execution of SQL statements occurs on the machine where the SQL server is started using the OpenEdge Broker.
The execution of all SQL statements is performed on the server.
The execution of SQL read-only statements does not affect on the growth of the bi file.
The application and the SQL statement execution are synchronous, cooperating processes, communicating over a network link. An fast executing SQL query has a positive impact on the application performance subject to the availability of a reasonably fast network link between the application and the SQL server process. Conversely, an SQL query that takes a long time to return its result set has a negative impact on the application performance regardless of the speed of the network link between the application and the SQL server process.
Some SQL query performance factors include: proper indexing, regular updating of table, index and column statistics, query complexity, size of result set, etc.