Use the scan and filter rows option.

Namespace: Hypertable.Fluent
Assembly: ht4n (in ht4n.dll) Version: 0.9.8.11 (0.9.8.11)

Syntax

         
 C#  Visual Basic  Visual C++ 
IScanSpecBuilderOp ScanAndFilter()
Function ScanAndFilter As IScanSpecBuilderOp
IScanSpecBuilderOp^ ScanAndFilter()

Return Value

The scan specification common options and limits builder.

Remarks

The scan and filter rows option can be used to improve query performance for queries that select a very large number of individual rows. The default algorithm for fetching a set of rows is to fetch each row individually, which involves a network roundtrip to a range server for each row. Supplying the scan and filter rows option tells the system to scan over the data and filter the requested rows at the range server, which will reduce the number of network roundtrips required when the number of rows requested is very large.

Scan and filter should be used if query more than 10% of all rows in a table.

See Also