Hey!
We have the need to be able to do a full search on the entire JSON in the collection. Something where the user can enter almost any text and we will give them a list of results with every document where that text was found.
To do this, I created three Atlas Search index (English, French and Spanish) on every collection (21). After doing so, my Query Targeting went from sub 10 to 3/4000 every 5 minutes, and we are not even using the DB. It looks like it does that every time the index are updating themselves maybe?
Is there a way to fix this? Or I am using the wrong tool to do the job I need to get done? We used to do that in ES where I was working before and we had no problem at all. Is there a way to do this with Mongo Atlas?
Here is how I created my indexs:
{
"analyzer": "lucene.english",
"searchAnalyzer": "lucene.english",
"mappings": {
"dynamic": true
}
}
Thank you in advance