Set Index Performance
Aerospike Database 5.6 introduces the set-index feature, which allows specific sets within a namespace to be directly indexed. This feature is particularly beneficial for smaller sets as it significantly reduces the cost of scanning and retrieving records. The tests performed in this study show that the advantages of set indexes diminish as the set size approaches that of the enclosing namespace due to the increased relevance of the retrieved records. However, even at the limit, the additional memory consumed by the index causes only a small degradation in performance. Overall, set indexes are a clear win with Aerospike 5.6, providing improved scan times and efficient resource utilization.
Company
Aerospike
Date published
June 30, 2021
Author(s)
Paul Jensen
Word count
905
Hacker News points
None found.
Language
English