Mail app MacOS not searching

Hi all,

I've noticed that my app mail doesn't work well anymore. Anytime I try to search it gives me 0 results, or if any results appear, they will take minutes to come.

I've tried rebuilding the mailbox, tried to rebuild the spotlight. Deleted the V10 folder, updated to Sonoma beta version. Nothing seems to make it work.

Some of my mail boxes only have around 1000 emails and always worked fine. Is there any way to freshly install the app ? or only a new macOS installation will sort this out ?