I have roughly 3.2 million documents and have created text index on one filed. It took me about an hour to complete index.
I notice that search is very very slow. I'm executing following statement.
and it's taking me roughly 2 minutes to return result which is not acceptable for any serious use. I have attached full explain output for your review.
I'm wondering if there is any way to improve it's performance?