GetRange operation for lists
174
Views
0
Comments
New
Builtin & User functions

We have many List operations both on client and server-side, however we don't have one that would return a range (a subset) of a list, for the provided index and count parameters.

This action would correspond to .NET's List.GetRange(index, count) method.

An example use-case would be:

- We have a large list with 1M+ records

- We want to bulk process these records (e.g. BulkInsert) but want to avoid poor performance

- In a loop, we get a subset of these records (e.g. 50K records) and do a bulk operation

- We adjust the index parameter of ListGetRange and get the next batch of 50K records to process


The current workaround is using a foreach and ListAppend, or adding additional code to make it work.