Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Filtering by scope is very slow on MongoDB side. #659

Closed
afalaleev opened this issue May 15, 2019 · 0 comments
Closed

Filtering by scope is very slow on MongoDB side. #659

afalaleev opened this issue May 15, 2019 · 0 comments
Assignees
@afalaleev
Milestone
Sprint-may-14

Comments

@afalaleev
Copy link 

db.vote.find({"_SERVICE_.scope" : "cnz23yqrff2j"}).hint("messageid").min({"_SERVICE_.scope" : "cnz23yqrff2j", "message_id" : NumberDecimal("7765412"), "id" : NumberDecimal("0")})

works very slow.

When this is works fast:

db.vote.find().hint("messageid").min({"_SERVICE_.scope" : "cnz23yqrff2j", "message_id" : NumberDecimal("7765412"), "id" : NumberDecimal("0")})

It is better to filter by scope on node-side.
@afalaleev afalaleev self-assigned this May 15, 2019
@afalaleev afalaleev added this to the Sprint-may-14 milestone May 15, 2019
@afalaleev afalaleev changed the title Filtering by scope is too slow on MongoDB side. Filtering by scope is very slow on MongoDB side. May 15, 2019
@afalaleev afalaleev mentioned this issue May 16, 2019
Merged
afalaleev added a commit that referenced this issue May 16, 2019
@afalaleev
Filter scope on MongoDB-driver side. #659
f2f5aef
afalaleev added a commit that referenced this issue May 16, 2019
@afalaleev
Merge pull request #680 from GolosChain/659-filter-scope-in-mongodb-d…
8d25d75 
…river

Filter scope on MongoDB-driver side. #659
@afalaleev afalaleev mentioned this issue May 17, 2019
Merged
afalaleev added a commit that referenced this issue May 17, 2019
@afalaleev
Merge pull request #686 from GolosChain/659-filter-scope-in-mongodb-d…
1da8961 
…river

Filter scope on MongoDB-driver side. #659
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@afalaleev afalaleev

Labels
None yet
Projects
None yet
Milestone
Sprint-may-14
Development

No branches or pull requests
1 participant
@afalaleev