Large object threshold (kilobytes)

Specifies the maximum large object (LOB) size (in kilobytes) that can be retrieved as part of a result set. LOBs that are larger than this threshold are retrieved in pieces using extra communication to the system. Larger LOB thresholds reduce the frequency of communication to the system, but will download more LOB data, even if it is not used. Smaller LOB thresholds are may increase frequency of communication to the system, but will only download LOB data as it is needed.