[w3c/IndexedDB] Projection Support (#366)

We have some tables that contain columns that can be relatively large, but these large columns aren't actually needed in many or our queries. Of course, we could split the tables, but this isn't desirable due to the additional management overhead and deviation from the expected / "natural" schema.

API Proposal
```
request = store.getAllProjection(keyPath, query [, count])
request = index.getAllProjection(keyPath, query [, count])
```
Retrieves partial data as specified by `keyPath` (as specified in section 2.5 of the IndexedDB spec) for the records matching the given key or key range in query (up to count if given).

This should enable significant performance gains at least in the case where keyPath can be satisfied from an index.

To my understanding, there is currently no way to obtain the index "content" by any other means (other than using cursors or fetching the full rows).



-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/w3c/IndexedDB/issues/366

Received on Thursday, 14 October 2021 15:26:04 UTC