[GitHub] jayachandra02 opened a new issue #836: View is taking long time for first request on 70 GB documents and impacting on couch DB server

[gi...@git.apache.org]

jayachandra02 opened a new issue #836: View is taking long time for first request on 70 GB documents and impacting on couch DB server
URL: https://github.com/apache/couchdb/issues/836
 
 
   Hi All,
   
   In our organization we recently(about 3 months ago) started using couchDb (Apache CouchDB 1.5.0) to fulfill requirement. As first part we have created one database and started storing documents in the couchdb. After that we added one view to access records using this. Which was fine working as expected with query filter. 
   
   **As per couchDb documentation when views are accessed for the first time it takes time to create indexs on database documents**. In our first view it has taken time (max 10 mins) on top of  2 millions documents with size of 3 GB.
   
   When we added new view recently and trying to access the first time it was taking long time and also effected other views(not sure but gone down).  Now  database size increased to 70 GB and has 8.5 millions records. 
   
   Is there any way to do this index offline with out effecting on couchDb or taking dump doing indexing locally and re importing back to database ? 
   
   And we are also planning to remove old documents form couch db please help us how can we do this ?
   I found only document wise. I want delete bulk wise with filter query like "delete from database where document.date < 'till date to purge' "
   
   
   Appreciate your help here.
   
   -Jaya
   
   
 
----------------------------------------------------------------
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