NexusDB

If a filter is applied to a 10,000,000 row table and returns 10 rows, it won't be instantaneous because NexusDb will process all 10,000,000  rows looking for the 10 that satifies the filter. This is  sloooowwwww. Why?

That is, by definition, the fundamental difference between a table and a query. Query's pre-process and return result sets. Table's are direct cursors into the data for navigational data access.