You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@couchdb.apache.org by GitBox <gi...@apache.org> on 2018/02/01 08:39:46 UTC

[GitHub] PascalPuchtler opened a new issue #1137: Execution of queries takes a lot of time

PascalPuchtler opened a new issue #1137: Execution of queries takes a lot of time
URL: https://github.com/apache/couchdb/issues/1137
 
 
   In my database I like to run requests data over a view. After the Request the database takes a long time to update the index, but the index has no changes. This takes about 6 minutes.
   When the index is ready the execution of the reduce step takes about 1 minute.
   
   ## Expected Behavior
   The index schoul only update if changes happened or should be everytime up to date.
   The request should execute faster.
   
   ## Current Behavior
   The index updates when no changes happened.
   The request should execute very long.
   
   ## Possible Solution
   No Idea.
   
   ## Steps to Reproduce (for bugs)
   Its not so easy, because of the "big" amount of data.
   
   ## Context
   **Request:**
       "ids": {
         "map": "function (doc) {    emit([doc.Header.Serialnumber, doc.Header.Parameter, doc.Header.Time],1);  }",
         "reduce": "_count"
       }
   
   **Data:**
   The size of the database is 5GB with 100k documents.
   
   ## Your Environment
   <!--- Include as many relevant details about the environment you experienced the bug in -->
   * Version used: v2.1.1
   * Browser Name and version: Firefox 52.1.2 (64-Bit)
   * Operating System and version (desktop or mobile): Windows 10 Enterprise 2015 LTSB
   * CPU: Intel i5
   * RAM: 16GB
   

----------------------------------------------------------------
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