fetch_lob_as_long

Description

Using this setting can improve network and database server performance because it:

• Reduces the number of network packages required for each retrieve transaction.
• Reduces the load on the database server.

Instead of first requesting the length of the CLOB, it fetches the first part of the data in the CLOB together with the fixed part of the record.

Normally, when using CLOB for segmented fields, the connector first fetches a set of row IDs or primary keys, and then fetches the required records. This prevents unnecessary fetches of very large records in the hitlist, but it increases the number of network packages, especially when there are many users on a WAN.

When using LONG for segmented fields, the connector fetches as many records as fit in the allocated data memory, including the first segment of the large field.

Note:  It is only possible to fetch one segmented field as LONG. Additional segmented fields are fetched as CLOB.