N1QL and Lookup documents

SQL++
1

Hi!

I use lookup document to store keys and then, i provide these keys to a N1QL query like this:
select * from bucket use keys [keys1,…] where …

Is there a max number or a proposal limit, of the keys that i can provide to ‘use keys’ of N1QL and i have the same performance?
This depends on hardware?

I have couchbase server 4, java 1.7 and my couchbase driver version is 2.1.4

2

Hi,

The max request size is 64MB/
A “use keys” clause results in an in-memory scan of the keys in the array
So performance would be of the order of the array size.

Thanks

Todd

3

Thanks for your answer Todd!