delay advice - Huge resultsetmysql replication delay very seriousMySQL 5.6 Delayed Replication - cancel delay...
Derivative of an interpolated function
Is divisi notation needed for brass or woodwind in an orchestra?
Why doesn't Gödel's incompleteness theorem apply to false statements?
What is the purpose of using a decision tree?
If the Dominion rule using their Jem'Hadar troops, why is their life expectancy so low?
Why is implicit conversion not ambiguous for non-primitive types?
Output visual diagram of picture
What is it called when someone votes for an option that's not their first choice?
Why didn’t Eve recognize the little cockroach as a living organism?
Why would five hundred and five same as one?
How do you say "Trust your struggle." in French?
How to test the sharpness of a knife?
Is there any common country to visit for persons holding UK and Schengen visas?
Exposing a company lying about themselves in a tightly knit industry (videogames) : Is my career at risk on the long run?
Connection Between Knot Theory and Number Theory
Relations between homogeneous polynomials
Calculate Pi using Monte Carlo
Put the phone down / Put down the phone
What is the meaning of "You've never met a graph you didn't like?"
is this saw blade faulty?
New Order #2: Turn My Way
Not hide and seek
C++ lambda syntax
"Oh no!" in Latin
delay advice - Huge resultset
mysql replication delay very seriousMySQL 5.6 Delayed Replication - cancel delay questionsCause of delay after use `$database`When rows of a resultset are generated?Simple database structure adviceCannot retrieve resultset dataMySQL Query optimisation adviceGoogle Cloud SQL Replication DelayInnodb updates records with delayAdvice Regarding Database Design
I have a mysql multi select query that performs inner left joins. These queries UNION with two other tables. The resultset is huge (250k+ rows). My client wishes to expose this resultset to a webpage. The infinite scroll methodology used on the webpage calls the above query with an offset limit - 50 rows per call. The time taken to retrieve the above dataset is 7+secs.
Can anyone offer any advice as to how this delay could be reduced?
mysql
asked 3 mins ago
teabgg99teabgg99
1
add a comment |
I have a mysql multi select query that performs inner left joins. These queries UNION with two other tables. The resultset is huge (250k+ rows). My client wishes to expose this resultset to a webpage. The infinite scroll methodology used on the webpage calls the above query with an offset limit - 50 rows per call. The time taken to retrieve the above dataset is 7+secs.
Can anyone offer any advice as to how this delay could be reduced?
mysql
asked 3 mins ago
teabgg99teabgg99
1
add a comment |
I have a mysql multi select query that performs inner left joins. These queries UNION with two other tables. The resultset is huge (250k+ rows). My client wishes to expose this resultset to a webpage. The infinite scroll methodology used on the webpage calls the above query with an offset limit - 50 rows per call. The time taken to retrieve the above dataset is 7+secs.
Can anyone offer any advice as to how this delay could be reduced?
mysql
asked 3 mins ago
teabgg99teabgg99
1
I have a mysql multi select query that performs inner left joins. These queries UNION with two other tables. The resultset is huge (250k+ rows). My client wishes to expose this resultset to a webpage. The infinite scroll methodology used on the webpage calls the above query with an offset limit - 50 rows per call. The time taken to retrieve the above dataset is 7+secs.
Can anyone offer any advice as to how this delay could be reduced?
mysql
mysql
asked 3 mins ago
teabgg99teabgg99
1
asked 3 mins ago
teabgg99teabgg99
1
asked 3 mins ago
teabgg99teabgg99
1
asked 3 mins ago
teabgg99teabgg99
1
asked 3 mins ago
teabgg99teabgg99
1
1
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
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%2fdba.stackexchange.com%2fquestions%2f232575%2fdelay-advice-huge-resultset%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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.
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%2fdba.stackexchange.com%2fquestions%2f232575%2fdelay-advice-huge-resultset%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
