You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Stats say that we have scrolled through all id: 1 tuples until we have filtered ones satisfying age: 15 condition.
The same scan is performed in case of crud.select('customers', {{'==', 'id', 1}, {'==', 'age', 12}}): the module does not treat age: 12 condition as the part of the index both to start and to stop.
The text was updated successfully, but these errors were encountered:
The ticket missing bug label since it's about request optimization and not related to some behavior described with either documentation or tests. However, we already had made similar thing for sharding key extraction: #242
Let's consider the space with multipart unique key. One can be obtained from the playground with the following patch.
If the conditions are specified with index, it is a simple "get by key" procedure.
Stats say that we have found the requested data without any scanning.
If the conditions are specified with fields, it is a scan over all tuples satisfying the first condition.
Stats say that we have scrolled through all
id: 1
tuples until we have filtered ones satisfyingage: 15
condition.The same scan is performed in case of
crud.select('customers', {{'==', 'id', 1}, {'==', 'age', 12}})
: the module does not treatage: 12
condition as the part of the index both to start and to stop.The text was updated successfully, but these errors were encountered: