I faced with a problem when result of the view fetches very slow.
I have test server that is not under loading (add ~50 documents per second). Sometimes something is happening and more impossible to get result from the view, I’m getting exception ‘remote host closed connection…’ .
this is my query:
It’s really simple query.
If in request specify limit parameter to 10 the query is executed, but it will take 30 seconds for fetching 10 small documents(!).
In CouchbaseConsole I can execute query with parameters and it executes very fast.
I’ve had this issue before but it is disappeared unexpectedly and I did not find the reason.
I need advice what I should to do or what to look on.
p.s. Sometimes couchbase makes me crying because hard to find the reason if something going wrong…
new version of .net client didn’t help. It works in the same way: slowly and with exception:"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host"