[GitHub] [couchdb] pavellzubkov opened a new issue #2236: Mango queries is fake?

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

pavellzubkov opened a new issue #2236: Mango queries is fake?
URL: https://github.com/apache/couchdb/issues/2236
 
 
   [NOTE]: # ( ^^ Provide a general summary of the issue in the title above. ^^ )
   
   $or $elemMatch $allMatch can't use index... i'm shocking. **search is impossible**... selector with that operators take more that 2 minutes on 50k simplied docs.
   
   [NOTE]: # ( Describe the problem you're encountering. )
   [TIP]:  # ( Do NOT give us access or passwords to your actual CouchDB! )
   
   create test data base "test_bulk" with 50k [docs](https://drive.google.com/open?id=1CdaYX9dcNTOHNp2yvFWym_RYW6CajKU5) with test field like "arr_test": ["Sdf3Kjew34"] (random value),
   
   `curl -X POST http://localhost:5984/test_bulk/_bulk_docs -H "Content-type: application/json" -d @docs.json`
   
   (by the way in result this curl i get 'badarg' error , but if i bulk 1000 docs after that i see in db 51000 docs. should i make separate issue for that?)
   
   make index on field "arr_test" then run query with selector {"arr_test":{"$elemMatch":{"$eq":"Sdf3Kjew34"}}}
   it takes more than 120 sec.... in explain i can see that querie using index on test field 
   
   [NOTE]: # ( Include commands to reproduce, if possible. curl is preferred. )
   
   ## Expected Behaviour
   
   queries result in less than 1 sec
   
   [NOTE]: # ( Tell us what you expected to happen. )
   
   ## Your Environment
   
   [TIP]:  # ( Include as many relevant details about your environment as possible. )
   [TIP]:  # ( You can paste the output of curl http://YOUR-COUCHDB:5984/ here. )
   
   * CouchDB Version used: 2.3.1 in docker configured in single node
   * Browser name and version: Chrome
   * Operating System and version: Win 10x64
   
   ## Additional context
   
   [TIP]:  # ( Add any other context about the prbolem here. )
   

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