The Table.Search method contains a parameter called useRecyclingCursor. However, the documentation on that parameter is cryptic to me:
If set to true, all the entries in RowCursor will reference the most current row returned by Current. To ensure all the entries in RowCursor remain unique, set useRecyclingCursor to false. The default is true.
Three questions on that:
Thanks.
Solved! Go to Solution.
A cursor is a data access object with an interface similar to the System.Collections.IEnumerator interface ( except Reset method). RowCursor.MoveNext() returns a Boolean representing whether the last record in the result has been returned. If the result is empty, the first call to RowCursor.MoveNext() will return false.
The recycling cursors offer performance advantages by allocating a single row object and rehydrating it on each fetch of reading data. They can be used to optimize read-only access.
Nonrecycling cursors return a unique instance for each row returned by MoveNext. The rows returned by a non-recycling cursor can be edited. For further details, please see the conceptual doc.
A cursor is a data access object with an interface similar to the System.Collections.IEnumerator interface ( except Reset method). RowCursor.MoveNext() returns a Boolean representing whether the last record in the result has been returned. If the result is empty, the first call to RowCursor.MoveNext() will return false.
The recycling cursors offer performance advantages by allocating a single row object and rehydrating it on each fetch of reading data. They can be used to optimize read-only access.
Nonrecycling cursors return a unique instance for each row returned by MoveNext. The rows returned by a non-recycling cursor can be edited. For further details, please see the conceptual doc.