Kbase P14344: 4GL: Does using a shared TEMP-TABLE yield better performance than passing a TEMP-TABLE handle?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/05/2011 |
|
Status: Verified
GOAL:
4GL: Does using a shared TEMP-TABLE yield better performance than passing a TEMP-TABLE handle?
GOAL:
Which is better from a performance point of view, passing a TEMP-TABLE handle or using a shared TEMP-TABLE?
GOAL:
Is there any difference in performance when using a shared TEMP-TABLE rather than passing a TEMP-TABLE as a parameter?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
There is no significant performance difference using a shared TEMP-TABLE vis-à-vis passing a TEMP-TABLE handle. From an Object Oriented Programming point of view it is preferable to pass the TEMP-TABLE handle than to use a shared TEMP-TABLE. The extra cost of defining a handle variable is more than offset by the benefits of modular programming and TEMP-TABLE scope control.