I have just about 3K json documents in bucket and each document size is about 1KB only.
Following are CB and machine details.
Couchbase - 4.0.0-4047 Enterprise Edition (Single server)
Total allocated RAM - 600MB
InUse - 254MB
RAM/Quota - 37.3MB/100MB
Data/DiskUsage - 35MB/40MB
Windows 7 64 bit , 4core AMD processor.
Using Java SDK client version 2.2.1
Querying against view takes approx 180millisec. I think this is still high considering very few documents are present in bucket. Using Stale=False and it’s development view.
If i run parallel requests to view the response time degrades a lot.
5 parallel calls = avg response time is ~230 millisec
10 parallel calls = avg response time is ~450 millisec
Please suggest if i need to modify any settings. Also is there any url/doc etc which discusses performance tuning as whole.
No documents are getting updated/created/deleted when I’m requesting view.
I tried using N1QL too but it was much worse than view when parallel queries are made. I did create covering index.