Kbase P98705: What is the difference between a parameter TABLE and TABLE-HANDLE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/16/2010 |
|
Status: Verified
GOAL:
What is the difference between parameters TABLE and TABLE-HANDLE
GOAL:
How to get more performance passing a temp-table as parameter
GOAL:
How a temp-table is passed from a procedure to another one in the same session
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
When a temp-table is passed as a parameter from one procedure to another, whether those procedures are in the same OpenEdge session or not, Progress copies the temp-table to make its data available to the called procedure. This can be very expensive if the temp-table contains a large number of records. If the call is made to a local procedure the handle of the temp-table should be passed instead of the table itself whenever possible. This avoids copying the table and can provide a significant performance advantage.