Details
-
Improvement
-
Resolution: Unresolved
-
Major
-
4.5.0
-
None
Description
N1QL currently does not sport the concept of cursors (which is not surprising since it's stateless), neither select nor insert.
Issue is - for bulk data loads via N1QL, executing inserts individually in a loop is painfully slow.
The REST API document describes batch_args, a list of list of positional arguments, which can be used to execute the same DML multiple times, over a list of arguments, within the same request.
That would speed up data loading a zillion times!
Slight issue - I have checked and it is not implemented
We would also need SDK support for it to make it usable.