Further to my last post here are the queries.
Large (2.2mb document)
select buc.entity.clientid from buc where buc.entity.objectid = 552910680
Creates huge network spike on local machine where CBQ is running, even for small response.
select buc.entity.clientid from buc where buc.entity.objectid = 552394365
Create no discernable network spike
The field being selected is one small number, yields this response in both instances
Hence I guess all the json is returned from Couch to CBQ for processing. If this is the case, I'm wondering whether there are plans for N1QL to live 'in' the cluster. It would make sense from an IO perspective.