Details
-
Improvement
-
Resolution: Unresolved
-
Major - P3
-
None
-
None
-
Query Integration
Description
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?
Attachments
Issue Links
- related to
-
SERVER-17537 FTS should short circuit an OR search when .sort().limit() is used.
-
- Backlog
-