Kbase P33456: Query resolution under DataServers different for Static and Dynamic queries
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/20/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
DataServers
SYMPTOM(s):
Query resolution under DataServers different for Static and Dynamic queries
Bad performance when running a dynamic query
The same query ran dynamically has better performance
A static query which joins two (or more) tables is performed on the server side.
The same query when opened dynamically, is performed on the client side
CAUSE:
Enhancement Request# OE00092455
CAUSE:
This is expected behavior. There is no support for join-by-the-server for any DataServer for dynamic queries.
FIX:
Use static queries.