commit 03f54320860eb959cb6d41f7bb7827caa738f1e8
author Robert Newson <rnewson@apache.org> Tue Sep 26 12:29:27 2023 +0100
committer Robert Newson <rnewson@apache.org> Tue Sep 26 12:38:38 2023 +0100
tree 8ec0b968fea2771d9c4db988cf4ad7b7f63ab416
parent b6ea325ccb1e3de45f8541ca4fde225ac75f7d54

use text prefix in regex to speed up query

for selector;

{"selector":{"_id":{"$regex":"doc.+"}}}

before;

{
  "include_docs": true,
  "view_type": "map",
  "reduce": false,
  "partition": null,
  "start_key": [],
  "end_key": [
    "<MAX>"
  ],
  "direction": "fwd",
  "stable": false,
  "update": true,
  "conflicts": "undefined"
}

after;

{
  "include_docs": true,
  "view_type": "map",
  "reduce": false,
  "partition": null,
  "start_key": [
    "doc"
  ],
  "end_key": [
    "doc�",
    "<MAX>"
  ],
  "direction": "fwd",
  "stable": false,
  "update": true,
  "conflicts": "undefined"
}

closes: https://github.com/apache/couchdb/issues/4775