We have actually 2 nodes of Couchbase with 16GB of ram and 4 cores. We are planning to switch to 3 nodes of Couchbase, all with 32GB of ram. We made some benchmark tests and we discovered that the performance of the get operations (with multiple ids) were the same no matter how much ram Couchbase server and/or buckets they had. This let us think that probably the amount of ram we have is enough to cache the most used keys we have, so more ram doesn’t impact performances.
All our operations are executed by chunking the keys to retrieve into a batch of documents, actually 2500, because getting more documents the script executed on the application server crashes with the error Client Side Timeout. How can we avoid this error and speed up the retrieve operation?
Is there a limit on the maximum number of documents retrieved by the (multi) get operation? Or is it related to the size of the cluster on which Couchbase is running?
The documents used on the test have a size of about 2kb and a key of about 15 bytes.