N1QL 200x slower than views for simple queries

Couchbase Server
39

If your resultset is large, please use change the batch size to higher value.
We have additional fix to improve data transfer rate from query service to client in Couchbase release 4.6. Thanks.

curl -u Administrator:password http://localhost:8093/admin/settings >z.json
Edit the z.json & increase servicers Example:

{"completed-limit":4000,"completed-threshold":1000,"cpuprofile":"","debug"
:false,"keep-alive-length":16384,"loglevel":"INFO","max-parallelism":1,"me
mprofile":"","pipeline-batch":16,"pipeline-cap":512,"request-size-cap":671
08864,"scan-cap":0,"servicers":32,"timeout":0}

    CHANGE the relavant values.  
    E.g., Your queries are getting large number of documents for each query.
    Increase pipeline-batch to 1024 and pipeline-cap: 4096

    Do the following:

    curl -u Administrator:password http://localhost:8093/admin/settings
    -XPOST -d@./z.json
2 Likes