The maximum number of rows to scan when generating table metadata. Set this property to gain more control over how the provider detects data types.

Syntax

Connect-HarperDB -RowScanDepth string

Data Type

cstr

Default Value

"100"

Remarks

This property is used when generating table metadata and specifically is used to retrieve the data to detect the data type for each column. Setting a high value may decrease performance. Setting a low value may prevent the data type from being determined properly, especially when there is null data.

HarperDB is schemaless and thus does not identify data types. The columns in a table must be determined by scanning table rows.