Re: Re. CouchDB - Performance Optimization Best Practices for indexing and searching in the context of HLF solution - V2.2.0 & CouchDB 3.1.0
There is indeed an automated performance test that runs nightly that would catch any performance regressions.
Dear Dave and community,
My apologies for coming out with this question - this bad:
>>> You are asking an impossible question, and to the wrong community :-)
First the question is always in the context of Hyperledger Fabric and not a CouchDB performance or scaling question.
I understand - this is not what we do in this forum and in our community.
I already have an answer for your concern.
A correctly designed solution that scales and performs using CouchDB can be learnt from CouchDB community or books - such as:
Regarding your comments:
>>> It is impossible to answer because there are too many variables. Only you can answer this question based on trials using your specific data schema, data volume, hardware, indexes, queries, and query load.
>>> And it is a CouchDB performance question, not a Fabric performance question. Test against CouchDB without Fabric
I could agree and understand the above response.
So the question becomes - is this more CouchDB capability to support KV versioned object store for rich queries role/scaling needs or are we dealing with a BigData and/or BigQuery kind of ask.
This is a good point and I would not know unless I further qualify the domain use case and context.
I can also accept and understand - experiment, fail fast and adjust response - perhaps Caliper may play a role and we can suggest this concept [basically we can not provide ready answers and need investigation].
If you look at my last referenced URL - Senthil's paper - that actually has a focused guidance and insights gained - when using CouchDB versus LevelDB.
This is what I was wondering in the context of my question - especially moving from v2.3.1 to 3.1.0 - have we seen performance improvements [by replication or with caching or by exploiting newer capabilities], etc.
So - a better way to ask perhaps - do we have a performance regression harness - that shows some understanding of how CouchDB performs - between releases with newer features and between CouchDB and LEVELDB.
Do we have a follow-up to Senthil's paper - that features current release insights?
Thank you for your offchain DB design pointer and I am aware of it - but did not bring it in since it is a valid proposition.