Hitting a limit of 50000 items

MongoDB Atlas
, , ,
1

Here is my function

    if(filter.query.category)
    {
      strCategory = filter.query.category;
      strMustData["must"].push({"text": {"path": "category","query": strCategory}});
    }
    
     const filteredItems = await collection.aggregate([
      {
        $search: {
          index: "productIndexes",
          "compound": {
            "must": 
              strMustData.must
          }
        }
      },
        
      {
        $project: {
          "_id": 10,
          "title": 1,
          "object": 2,
          "price":3,
          "imgArray":6,
          "category": 7,
          score: { $meta: "searchScore" }
        }
      }
    ]).toArray();
      return filteredItems;

I pass a category ID and get the data and it returns the data but its only returns 50000 items

Capture

there is more than this in the data but i am only returning the 50000 is there a way to remove this limit

3

Hi @Aneurin_Jones and welcome to MongoDB community forums!!

As per my understanding, there is no limit on the results obtained by the query.
However, to understand further could you help me with some information which would help me reproduce the issue.

  1. The total number of documents in the collection.
  2. Can you confirm if the number of resultant document after search operation is more than 50000?

Regards
Aasawari

1 Like
4

Hi @Aasawari,

I’m having the same issue. I’m doing the below with the C# graphql client.

GraphQLHttpRequest mqRequest = new()
            {
                Query = @"
                    query {
                        myTable (limit: " + int.MaxValue.ToString() + @")
                        {
                            _id,
                            partition
                        }
                    }
                "
            };

I have around 66k documents. It’s returning only 50k.

Thanks,

Tam

5

Oh I see there’s a service limitation of 50k documents returned for standard clusters.