lobcachesize

lobcachesize setting sets the client-side ResultSet LOB cache size. It affects CLOB / BLOB / XML types. The cache is mainly used for sorting purposes.

This is an interpreter level setting.

By default, it is 4096.

Syntax

usage: .set lobcachesize [size]

Without the size argument, it displays the interpreter’s current LOB cache size.

Example

.set lobcachesize 64000
.sort 2, 3
SELECT * FROM XmlTable ORDER BY a;

See Also