Couchbase 2.0 view performance
I'm running some performance becnhmarks on Couchbase 2.0 with a view to using it in a high throughput credit card related application.
On a simple 1 node cluster I can get 20,000+ insertions per second for simple JSON records. In total, the test database contains 10 million records. The problem is with retrieval performance.
Insertions are done using a unique transaction reference for the key field. I have set up a view indexed on credit card number to retrieve all transactions for a particular card - typically 10 or fewer. I find that the retrieval rate is around 200 queries per second, or 1% of the insertion rate.
Is this kind of result expected or is there likely to be something wrong with the way I have set up my benchmark test?