bigcouch very slow with views extrem performance problem

[David]

Hi,

I have a problem with a 3 node bigcouch cluster. When using a view it takes up to 8 seconds in this case up to 2 seconds until bigcouch answers.

22542 2016-12-12 20:42:05.393442 x.x.x.219 x.x.x.220 HTTP 313 GET /account%xxx%2Fc7%2xxxxxxx13017exxxxxxxxx65/_design/devices/_view/sip_credentials?key=%22user_xxxxxx%22&include_docs=true HTTP/1.1 

22543 2016-12-12 20:42:05.393452 x.x.x.220 x.x.x.219 TCP 66 5984 → 35455 [ACK] Seq=1 Ack=248 Win=6993 Len=0 TSval=107083657 TSecr=19501476

22613 2016-12-12 20:42:07.399080 x.x.x.220 x.x.x.219 TCP 335 [TCP segment of a reassembled PDU]

22616 2016-12-12 20:42:07.399307 x.x.x.219 x.x.x.220 TCP 66 35455 → 5984 [ACK] Seq=248 Ack=270 Win=15744 Len=0 TSval=19501977 TSecr=107084159

22617 2016-12-12 20:42:07.399333 x.x.x.220 x.x.x.219 TCP 111 [TCP segment of a reassembled PDU]

22621 2016-12-12 20:42:07.399530 x.x.x.219 x.x.x.220 TCP 66 35455 → 5984 [ACK] Seq=248 Ack=315 Win=15744 Len=0 TSval=19501977 TSecr=107084159

22622 2016-12-12 20:42:07.399826 x.x.x.220 x.x.x.219 TCP 1514 [TCP segment of a reassembled PDU]

22623 2016-12-12 20:42:07.399841 x.x.x.220 x.x.x.219 TCP 1281 [TCP segment of a reassembled PDU]

22624 2016-12-12 20:42:07.399968 x.x.x.219 x.x.x.220 TCP 66 35455 → 5984 [ACK] Seq=248 Ack=1763 Win=18688 Len=0 TSval=19501977 TSecr=107084159

22625 2016-12-12 20:42:07.400021 x.x.x.219 x.x.x.220 TCP 66 35455 → 5984 [ACK] Seq=248 Ack=2978 Win=21504 Len=0 TSval=19501977 TSecr=107084159

22626 2016-12-12 20:42:07.400029 x.x.x.220 x.x.x.219 TCP 75 [TCP segment of a reassembled PDU]

22627 2016-12-12 20:42:07.400187 x.x.x.219 x.x.x.220 TCP 66 35455 → 5984 [ACK] Seq=248 Ack=2987 Win=21504 Len=0 TSval=19501978 TSecr=107084159

22628 2016-12-12 20:42:07.400197 x.x.x.220 x.x.x.219 HTTP 77 HTTP/1.1 200 OK  (text/plain)

Anybody an idea what could be the problem? We did all the configuration for the cluster like this:

[cluster]

; Default number of shards for a new database

q = 1

; Default number of copies of each shard

n = 3

; speed up reads

r = 1

; secure writes

w = 2

Thanks for helping.