It is wierd! i have the same problem my data set consists of 3500 json documents and each has 10-30kb sized Json documents.
Everytime i run a query Which uses a very easy map function (emits just meta.id and doc itself) it takes 0.6s then 10s and 0.8s 1.5s so on for fetching 50 Json documents.
all tests were executed with just one client that retrieves 50 json documents from default bucket.
I have been using .Net sdk 1.2.4. My application is .net windows form application.
If I run this software 5 clients at the same time, retrieval time is getting longer. This software easily executes a query on a view then enumerates the result and adds a gridview to show
My server has 2 nodes total 6gigabytes of ram for bucket and 9terra bytes of disk space (6 terrabytes for data files and 3 terrabytes for index files each are on different scsi disks)
2x8 core processor.
I have only one bucket which is default bucket for this simple test nothing else!!!
Why query times for same view differs so much each time I execute???
Why couchbase can not handle this easy test data retrieval operation?