I’m seeing extremely inconsistent results when trying to retrieve values for a key from my views. Basically, a view request can take anywhere from 40ms to 2s. It doesn’t matter if it’s a new request or the same one, each time I run the query, the time to complete the request is totally unpredictable.
I have approximately 1.5 M records, on a cluster of 3 EC2 instances running 2.0. I’m using ‘stale=ok’ to insure that I’m not forcing a reindex. Get/Set performance is fantastic- I only have issues when attempting to retrieve values from views.
I have tried this using both libcouchbase with the couch node.js project, and with direct HTTP requests; the performance is equivalent.
Any ideas as to what would cause these kinds of issues? What tools would you recommend for identifying bottlenecks?