Consultor Eletrônico



Kbase P7966: Shall I pass a big temp table in WS?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   15/10/2008
Status: Verified

GOAL:

Shall I pass a big temp table in WS?

GOAL:

Is it a good practice to pass a big temp table in WS?

GOAL:

How to work around passing big temp tables in webspeed?

FIX:

Its not a good practice to pass big temp-tables in webspeed code, as it may cause a lot of network traffic. However consider following options:

1) Store the temp-table information in a cookie on the server machine and have the second program read the temp-table information form cookie. The problem however with this option is the size of the cookie, which is limited to 4Kb.

2) The temp-table information can also be stored in a temporary file on the
server machine. The second program can easily read the file and work with the
data.

You could also pass the UUID of the session in a hidden value, to preserve the
session context, as many sessions could create different temporary files.