Cursors in query resultset?

n1ql
#1

Hi all,

I am new to couchbase. I followed several of the online courses which have been ideal in getting to know the database and N1QL in specific.
I installed the SDK and used it a bit.
One thing I find strange is the lack of cursors in the returned queries. I see that an array with all documents is returned, which is not that memory friendly

Any plans of adding support for a more memory efficient way of retrieving the resultset?

Regards

#2

Cursors are much more common in the non-distributed database world which is also most often disk IO driven, where Couchbase is much more streaming and memory oriented. In that environment, you have a stateful connection which is iterating a result set that may be disk buffered.

While it’s possible that we might add something akin to cursors on the cluster in the future, that doesn’t exist today so there’s nothing to expose in PHP.

For many situations, the use of OFFSET and LIMIT in queries is sufficient.