[GitHub] mohshraim opened a new issue #981: Feature; is it possible to have collection level above document?

[GitBox <gi...@apache.org>]

mohshraim opened a new issue #981: Feature; is it possible to have collection level above document?
URL: https://github.com/apache/couchdb/issues/981
 
 
   Iam with SQL background and new to couchDB...
   
   The feature is if its possible to have extra level between the DB and Document.
   
   i want to transfer my current inventory system to couchDB.
   When i have many DBs each one contains 3-4 mill up to 10 mill records, original come from 40 entity. its not practical to add around 30 - 40 views to generate my reports. that each view have to read the on average 5 mill record(document) to generate related index.
   and its not reliable to open separate 40 DB for each client..
   So main reason of this feature request to make my DB organized and to be able to generate the view on collection level and saving machine resources.
   
   ### **Current scenario -- of 5 mill record and 40 index --> 
   5 mill * 40 = **_200 mill read operation_** 
   
   ### **Collection Scenario --of 5 mill record DEVIDED EQUALLY ON 40 COLLECTION and 80 index as 2 per collection -
   -> 
   5 mill / 40 collection * 80 = **_8 mill read operation_** with doubled index for more control..
   
   if someone ask why to have many indexes... the answer that most of application entity is transactional type and system doing automated operations according to these transaction plus advance dashboard..
   
   I didnt find any issue or feature request talking about collection. so just open this and hope someone help me with any suggestion
   
   Thanks
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services