This repository was archived by the owner on May 14, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 76
ITER
Josh Baker edited this page Oct 11, 2016
·
14 revisions
Iterate through a specified index. This works in a similar manner to KEYS.
This operation is very fast because the values are stored in a B-tree. In SummitDB it's OK to use this operation in production.
Please keep in mind that the default LIMIT is 100. This is to keep from having an accidental ITER index command on an index with lots of values. When specified, LIMIT is not constrained to 100 and can be any positive number.
- PIVOT value - The results will include all keys past value
- RANGE min max - Constrain the result between specified range. To return a single item you should use the RANGE with min and max being the same value, and LIMIT equal to 1. The values -inf and +inf may be used for boundless ranges.
- LIMIT limit - Limit the number of results. The default is 100
- DESC - Return the results in descending order