Mixing
MongoDB- Is it possible not to use cache in order to test the speed of the query?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
1
I am using groovy language to implement MongoDB's queries. I want to test the speed of my query. But because of the cache, I am not able to predict it. I searched on google but I was not able to make it.
Problem: Is there any query that force MongoDB not to use the cache. I tried db.collection.getPlanCache().clear() in groovy language but it is not helping. Is there any way to handle it using groovy language?
mongodb caching groovy
asked Jan 3 at 9:12
AnkitAnkit
298
add a comment |
1
I am using groovy language to implement MongoDB's queries. I want to test the speed of my query. But because of the cache, I am not able to predict it. I searched on google but I was not able to make it.
Problem: Is there any query that force MongoDB not to use the cache. I tried db.collection.getPlanCache().clear() in groovy language but it is not helping. Is there any way to handle it using groovy language?
mongodb caching groovy
asked Jan 3 at 9:12
AnkitAnkit
298
add a comment |
1
1
1
I am using groovy language to implement MongoDB's queries. I want to test the speed of my query. But because of the cache, I am not able to predict it. I searched on google but I was not able to make it.
Problem: Is there any query that force MongoDB not to use the cache. I tried db.collection.getPlanCache().clear() in groovy language but it is not helping. Is there any way to handle it using groovy language?
mongodb caching groovy
asked Jan 3 at 9:12
AnkitAnkit
298
I am using groovy language to implement MongoDB's queries. I want to test the speed of my query. But because of the cache, I am not able to predict it. I searched on google but I was not able to make it.
Problem: Is there any query that force MongoDB not to use the cache. I tried db.collection.getPlanCache().clear() in groovy language but it is not helping. Is there any way to handle it using groovy language?
mongodb caching groovy
mongodb caching groovy
asked Jan 3 at 9:12
AnkitAnkit
298
asked Jan 3 at 9:12
AnkitAnkit
298
asked Jan 3 at 9:12
AnkitAnkit
298
asked Jan 3 at 9:12
AnkitAnkit
298
asked Jan 3 at 9:12
AnkitAnkit
298
298
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
0
try this db.collection.find(<query>).close()
answered Jan 3 at 9:15
Sumit SrivastavaSumit Srivastava
2419
I am using aggregation query which includes pipeline using Groovy language. How can I use the above query? Can you elaborate a little bit in groovy language?
– Ankit
Jan 3 at 9:35
Could you explain how this triggers MongoDB to avoid cache.
– Lex
Jan 3 at 23:49
@Lex I used a close() method. Still, I am not able to trigger MongoDB to avoid cache. I am also looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read.
– Ankit
Jan 4 at 6:07
add a comment |
0
Your groovy code should be like this.
db.getCollection('myCollection').aggregate(<pipeline>).close()
The call to .close() should free the resources as suggested here - .close()
answered Jan 3 at 10:59
Ravi Kumar GuptaRavi Kumar Gupta
7381029
Thanks, But I am reading data from MongoDB using aggregation. But I am getting Read: 0 KB/s. Even though the close() method instructs the server to close a cursor and free the associated server resources. Can you suggest how can I get this "Read"?
– Ankit
Jan 3 at 16:39
@Ankit Can you please share the screenshot of the output you are getting?
– Ravi Kumar Gupta
Jan 3 at 17:30
I am getting the correct output. But I am looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read percentage in Task manager.
– Ankit
Jan 4 at 6:13
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54019230%2fmongodb-is-it-possible-not-to-use-cache-in-order-to-test-the-speed-of-the-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
try this db.collection.find(<query>).close()
answered Jan 3 at 9:15
Sumit SrivastavaSumit Srivastava
2419
I am using aggregation query which includes pipeline using Groovy language. How can I use the above query? Can you elaborate a little bit in groovy language?
– Ankit
Jan 3 at 9:35
Could you explain how this triggers MongoDB to avoid cache.
– Lex
Jan 3 at 23:49
@Lex I used a close() method. Still, I am not able to trigger MongoDB to avoid cache. I am also looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read.
– Ankit
Jan 4 at 6:07
add a comment |
0
try this db.collection.find(<query>).close()
answered Jan 3 at 9:15
Sumit SrivastavaSumit Srivastava
2419
I am using aggregation query which includes pipeline using Groovy language. How can I use the above query? Can you elaborate a little bit in groovy language?
– Ankit
Jan 3 at 9:35
Could you explain how this triggers MongoDB to avoid cache.
– Lex
Jan 3 at 23:49
@Lex I used a close() method. Still, I am not able to trigger MongoDB to avoid cache. I am also looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read.
– Ankit
Jan 4 at 6:07
add a comment |
0
0
0
try this db.collection.find(<query>).close()
answered Jan 3 at 9:15
Sumit SrivastavaSumit Srivastava
2419
try this db.collection.find(<query>).close()
answered Jan 3 at 9:15
Sumit SrivastavaSumit Srivastava
2419
answered Jan 3 at 9:15
Sumit SrivastavaSumit Srivastava
2419
answered Jan 3 at 9:15
Sumit SrivastavaSumit Srivastava
2419
answered Jan 3 at 9:15
Sumit SrivastavaSumit Srivastava
2419
2419
I am using aggregation query which includes pipeline using Groovy language. How can I use the above query? Can you elaborate a little bit in groovy language?
– Ankit
Jan 3 at 9:35
Could you explain how this triggers MongoDB to avoid cache.
– Lex
Jan 3 at 23:49
@Lex I used a close() method. Still, I am not able to trigger MongoDB to avoid cache. I am also looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read.
– Ankit
Jan 4 at 6:07
add a comment |
I am using aggregation query which includes pipeline using Groovy language. How can I use the above query? Can you elaborate a little bit in groovy language?
– Ankit
Jan 3 at 9:35
Could you explain how this triggers MongoDB to avoid cache.
– Lex
Jan 3 at 23:49
@Lex I used a close() method. Still, I am not able to trigger MongoDB to avoid cache. I am also looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read.
– Ankit
Jan 4 at 6:07
I am using aggregation query which includes pipeline using Groovy language. How can I use the above query? Can you elaborate a little bit in groovy language?
– Ankit
Jan 3 at 9:35
I am using aggregation query which includes pipeline using Groovy language. How can I use the above query? Can you elaborate a little bit in groovy language?
– Ankit
Jan 3 at 9:35
Could you explain how this triggers MongoDB to avoid cache.
– Lex
Jan 3 at 23:49
Could you explain how this triggers MongoDB to avoid cache.
– Lex
Jan 3 at 23:49
@Lex I used a close() method. Still, I am not able to trigger MongoDB to avoid cache. I am also looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read.
– Ankit
Jan 4 at 6:07
@Lex I used a close() method. Still, I am not able to trigger MongoDB to avoid cache. I am also looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read.
– Ankit
Jan 4 at 6:07
add a comment |
0
Your groovy code should be like this.
db.getCollection('myCollection').aggregate(<pipeline>).close()
The call to .close() should free the resources as suggested here - .close()
answered Jan 3 at 10:59
Ravi Kumar GuptaRavi Kumar Gupta
7381029
Thanks, But I am reading data from MongoDB using aggregation. But I am getting Read: 0 KB/s. Even though the close() method instructs the server to close a cursor and free the associated server resources. Can you suggest how can I get this "Read"?
– Ankit
Jan 3 at 16:39
@Ankit Can you please share the screenshot of the output you are getting?
– Ravi Kumar Gupta
Jan 3 at 17:30
I am getting the correct output. But I am looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read percentage in Task manager.
– Ankit
Jan 4 at 6:13
add a comment |
0
Your groovy code should be like this.
db.getCollection('myCollection').aggregate(<pipeline>).close()
The call to .close() should free the resources as suggested here - .close()
answered Jan 3 at 10:59
Ravi Kumar GuptaRavi Kumar Gupta
7381029
Thanks, But I am reading data from MongoDB using aggregation. But I am getting Read: 0 KB/s. Even though the close() method instructs the server to close a cursor and free the associated server resources. Can you suggest how can I get this "Read"?
– Ankit
Jan 3 at 16:39
@Ankit Can you please share the screenshot of the output you are getting?
– Ravi Kumar Gupta
Jan 3 at 17:30
I am getting the correct output. But I am looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read percentage in Task manager.
– Ankit
Jan 4 at 6:13
add a comment |
0
0
0
Your groovy code should be like this.
db.getCollection('myCollection').aggregate(<pipeline>).close()
The call to .close() should free the resources as suggested here - .close()
answered Jan 3 at 10:59
Ravi Kumar GuptaRavi Kumar Gupta
7381029
Your groovy code should be like this.
db.getCollection('myCollection').aggregate(<pipeline>).close()
The call to .close() should free the resources as suggested here - .close()
answered Jan 3 at 10:59
Ravi Kumar GuptaRavi Kumar Gupta
7381029
answered Jan 3 at 10:59
Ravi Kumar GuptaRavi Kumar Gupta
7381029
answered Jan 3 at 10:59
Ravi Kumar GuptaRavi Kumar Gupta
7381029
answered Jan 3 at 10:59
Ravi Kumar GuptaRavi Kumar Gupta
7381029
7381029
Thanks, But I am reading data from MongoDB using aggregation. But I am getting Read: 0 KB/s. Even though the close() method instructs the server to close a cursor and free the associated server resources. Can you suggest how can I get this "Read"?
– Ankit
Jan 3 at 16:39
@Ankit Can you please share the screenshot of the output you are getting?
– Ravi Kumar Gupta
Jan 3 at 17:30
I am getting the correct output. But I am looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read percentage in Task manager.
– Ankit
Jan 4 at 6:13
add a comment |
Thanks, But I am reading data from MongoDB using aggregation. But I am getting Read: 0 KB/s. Even though the close() method instructs the server to close a cursor and free the associated server resources. Can you suggest how can I get this "Read"?
– Ankit
Jan 3 at 16:39
@Ankit Can you please share the screenshot of the output you are getting?
– Ravi Kumar Gupta
Jan 3 at 17:30
I am getting the correct output. But I am looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read percentage in Task manager.
– Ankit
Jan 4 at 6:13
Thanks, But I am reading data from MongoDB using aggregation. But I am getting Read: 0 KB/s. Even though the close() method instructs the server to close a cursor and free the associated server resources. Can you suggest how can I get this "Read"?
– Ankit
Jan 3 at 16:39
Thanks, But I am reading data from MongoDB using aggregation. But I am getting Read: 0 KB/s. Even though the close() method instructs the server to close a cursor and free the associated server resources. Can you suggest how can I get this "Read"?
– Ankit
Jan 3 at 16:39
@Ankit Can you please share the screenshot of the output you are getting?
– Ravi Kumar Gupta
Jan 3 at 17:30
@Ankit Can you please share the screenshot of the output you are getting?
– Ravi Kumar Gupta
Jan 3 at 17:30
I am getting the correct output. But I am looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read percentage in Task manager.
– Ankit
Jan 4 at 6:13
I am getting the correct output. But I am looking for a query or command to allow MongoDB not to use the cache (Means directly reads from the Disk) so that I can get the Read percentage in Task manager.
– Ankit
Jan 4 at 6:13
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54019230%2fmongodb-is-it-possible-not-to-use-cache-in-order-to-test-the-speed-of-the-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
