MongoDB Atlas Search - slow count of matched documents

Asked Sep 15 '20 at 12:10

Active Sep 15 '20 at 12:10

Viewed 1,721 times

I have a collection with 11M records, which contains among other properties, a "Name" property with a client name:

{
    "Name" : "Teressa Bella"
}

I have created an Atlas Search index on the "Name" field with the following definition:

{
  "mappings": {
    "dynamic": false,
    "fields": {
      "Name": {
        "analyzer": "lucene.standard",
        "type": "string"
      }
    }
  }
}

My use case counting all the documents that match a certain term which I'm doing like so:

db.getCollection('recipients').aggregate([
  {
    $search: {
      "text": {
        "query": "Teressa",
        "path": "Name"
      }
    }
  },
  {
    $count: "total"
  }
])

The problem is that this query takes about 40s to complete on an M30 Atlas cluster (sometimes 10s or 20s if entirely fetched from memory, I presume). Is this within the expected execution time for matching a term on 11M documents? I would appreciate any suggestions on how i can optimize this kind of query.

asked Sep 15 '20 at 12:10

djed

What was the value returned of `$count`? – Nice-Guy Sep 17 '20 at 23:49
About 80k records – djed Sep 18 '20 at 15:48
@djed did you find a solution for your problem. – Bathri Nathan Feb 19 '21 at 10:54
@BathriNathan no I didn't, however I didn't pursue the issue much further since then. – djed Mar 03 '21 at 14:52
@djed thanks for sharing this. hope we will get a solution for this soon. – Bathri Nathan Mar 03 '21 at 15:14

MongoDB Atlas Search - slow count of matched documents

0 Answers0