Details
Description
While running couchbase/DBNAME/_all_docs with a startkey & endkey & limit, it's very slow (1 minute). Example (and please note the view_merge error)...
$ time curl "http://127.0.0.1:8091/couchBase/default/_all_docs?limit=10&startkey=\"ff00d0d8c7445f24\"&endkey=\"ff0c\""
{"total_rows":54116,"rows":[
{"id":"ff00d0d8c7445f24","key":"ff00d0d8c7445f24","value":{"rev":"1-000002a4665c3f98000008ce00000000"}},
{"id":"ff0381b939a7c930","key":"ff0381b939a7c930","value":{"rev":"1-000002b05fc0e7e9000004cb00000000"}},
{"id":"ff051a2ee798b928","key":"ff051a2ee798b928","value":{"rev":"1-000002a252026173000008ca00000000"}},
{"id":"ff08ac919f10db64","key":"ff08ac919f10db64","value":{"rev":"1-000002a41f47701b000004d300000000"}},
{"id":"ff08c7b60b04ee8c","key":"ff08c7b60b04ee8c","value":{"rev":"1-000002a27d920659000004d000000000"}}
],
"errors":[
]
}
real 1m0.126s
user 0m0.002s
sys 0m0.007s
The total_rows also seems wrong, and should only be 5 not 54116.
In contrast on this system, getting a single document via HTTP/GET is the expected speed...
$ time curl http://127.0.0.1:8091/couchBase/default/ff00d0d8c7445f24
{"_id":"ff00d0d8c7445f24","_rev":"3-000002a4665c3f98000008ce00000000","$flags":0,"$expiration":0,"key":"ff00d0d8c7445f24","key_num":68600,"name":"ff00 5f2","email":"ff00@0d.com","city":"d0d","country":"8c","realm":"74","coins":652.8,"category":1,"achievements":[1,97,160,200,244,27,87],"body":"xc4ca4...750f"} real 0m0.010s
user 0m0.003s
sys 0m0.003s