[SERVER-12667] improve the performance of complex counts Created: 10/Feb/14  Updated: 10/Dec/14  Resolved: 20/Jun/14

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Ovidiu Anicai Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-9883 Performance issues with distinct and ... Closed
Participants:

 Description   

In SERVER-1752 you have optimized the speed for simple queries count
db.Comment.count(

{appId:1,topicId:1}

)

I think it would be very usefull an improvement for more complex queries.
Now for large collections counts like this are very slow
db.Comment.count({appId:{$in:[1,2]}})
db.Comment.count({$or:[

{appId:1}

,

{appId:2}

]})



 Comments   
Comment by Thomas Rueckstiess [ 20/Jun/14 ]

Hi Ovidiu, thanks for opening this request. We're already tracking the performance of distinct and complex count queries on SERVER-9883, as such I'll close this one as duplicate. Feel free to watch and comment on the other issue.

Regards,
Thomas

Generated at Thu Feb 08 03:29:12 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.