-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Text Search
-
Query Integration
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.
db.messages.explain("executionStats").find({$text:{$search:"Unfortunately"}},{"body":1}).limit(2)
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?
- related to
-
SERVER-17537 FTS should short circuit an OR search when .sort().limit() is used.
- Backlog