Kbase P134974: Poor performance passing ProDataSet containing large CLOB field from ABL client to AppServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/09/2008 |
|
Status: Unverified
SYMPTOM(s):
Passing ProDataSet from ABL client to AppServer
ProDataSet contains a single temp-table
Temp-table contains a single field which is a CLOB
Temp-table contains a single record containing a 7MB CLOB
Passing the ProDataSet to the AppServer takes between 40 seconds and 1.5 minutes
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
CAUSE:
The CLOB data is passed from the ABL client to the AppServer in 8K chunks. This requires approximately 900 TCP/IP round trips and depending on the performance of the network the speed will vary greatly.
FIX:
There is no real fix for this issue other than to consider ways (such as using external data compression routines) to reduce the amount of data being passed to the AppServer
Depending on the data in the CLOB you could also choose to work with NetWork Message Compression (-mc) which compresses the data on the wire.