rnewson commented on issue #5189: URL: https://github.com/apache/couchdb/issues/5189#issuecomment-2307302404
I recommend building a map-reduce view directly (queried via `_view` not `_find`). This is an actual index (on the emitted key), and any query you can do to `_view` will be done efficiently (`startkey`/`endkey` or `key` or `keys`) . All that `_find` does is look at all the indexes and tries to find the most efficient one for the selector. If it doesn't find one it just reads the whole database and filters out non-matches. In your case you could do the much more efficient `/dbname/_all_docs?keys=["CustomerElastic_00000a29-329f-477f-8d4a-8244a9c738aa", "CustomerElastic_00001280-7a18-466b-9e9c-da5a2d903bda"]` instead. -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
