I have a relatively simple query to update approx. 50.000 docs (total bucket is 450-500.000 docs) on a test server (two cluster nodes, each 6GB RAM, CouchbaseCE 6.0.0):
update data set statstriptarget=false where type="Catch"
I enter the query in the web admin interface. The query times out after 6 minutes (only having updated perhaps half of the docs). This seems way too slow - so something must be spoiling it for me. But how do I find out??
Thanks in advance!