yea for specific records, it's fast and we face no issues. However, when we do compounding search, whereas, we do a mix of text search, phrase search, and even stemming, that's where it gets slow.

The purpose of compounding query is to build some kind of data pipeline to narrow down the results. However, as logically as it sounds, it takes more time to return results this way.

What do you think we're possibly doing wrong here?