[GitHub] [couchdb] subin1011 opened a new issue #2013: selector filter in _changes API not using indexed search

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

subin1011 opened a new issue #2013: selector filter in _changes API not using indexed search
URL: https://github.com/apache/couchdb/issues/2013
 
 
   Working on Database with more than 3.5 lakhs documents
   ## Description
   When passing Selector query params to `POST /_changes?filter=_selector` API it is taking more than 600K ms to give the response where as `GET /_changes` API is taking less the 2 minutes
   
   The same Selector query params when passed to `POST /_find`  gives result in 500 ms. The Selector query used is indexed.
   
   
   After trying different approaches now I'm getting a feeling that selector query used in _changes API is not doing a indexed search.
   
   
   ## Steps to Reproduce
   
   1) Run Couchdb in Docker
   2) Create a database and create more that 3 Lakhs documents in it
   3) curl the API
   	POST {{db_name}}/_changes?filter=_selector
   
   	Request Body
       {
           "selector": {
               {{any indexed query}}
           }   
       }
   [NOTE]: # ( Include commands to reproduce, if possible. curl is preferred. )
   
   ## Current Behaviour
   Taking more than 10 minutes to give response
   ## Expected Behaviour
   Should take same time as `POST /_find` API ie., less than 1 second
   
   * CouchDB Version used: 2.3.0
   
   
   Would like to know if there is any way to speed up _changes API using selector filter.
   
   Thanks.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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