alexberriman / newtondb

A simple, easy to use and extendible JSON database.
https://github.com/alexberriman/newtondb
MIT License
17 stars 1 forks source link

Secondary indexes #3

Open alexberriman opened 2 years ago

alexberriman commented 2 years ago

Currently, an index is only created for the primary key of a collection. That means for every other query where the primary key is not included, the entire collection has to be scanned. If you were able to configure multiple secondary indexes, read operations could reference the hash table as opposed to scanning the linked list.