kobeyk opened a new issue #1853: The $in operator in _find makes the queries very slow URL: https://github.com/apache/couchdb/issues/1853 <!--- Provide a general summary of the issue in the Title above --> ## Expected Behavior First of all, I am a programmer from China. Here are my questions: `{ "limit": 20, "skip": 0, "fields": [ "_id", "fid", "_rev", "name", "des", "type", "fname", "extension", "mtime", "uid", "icon" ], "selector": { "$and": [ { "fid": { "$in": [ 3692398112768, 3701629775872, 3727986782208, 3781082476544, 3805799510016, 3841321070592, 3849785176064, 3695615143936, 3698387578880, 3721196204032, 3777047556096, 3785226448896, 3813181485056, 3831992938496, 3853979480064 ] } } ] }, "execution_stats": true }` The index has been established,But when the query, it doesn't seem to work? "execution_stats": { "total_keys_examined": 0, "total_docs_examined": 2935, "total_quorum_docs_examined": 0, "results_returned": 15, "execution_time_ms": 9942.517 } A total of 15 records, using nearly 10 seconds,Did I do something wrong?
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services
