Sybase IQ cache database resultHow to add a column with computed columns with values of row on Sybase...
Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?
Finding a mistake using Mayer-Vietoris
Normalization for two bulk RNA-Seq samples to enable reliable fold-change estimation between genes
Why would the Pakistan airspace closure cancel flights not headed to Pakistan itself?
Why is working on the same position for more than 15 years not a red flag?
What is 6÷2×(1+2) =?
Can I string the D&D Starter Set campaign into another module, keeping the same characters?
Citing paywalled articles accessed via illegal web sharing
Math Saturation Symbol
In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?
Why do neural networks need so many training examples to perform?
Are there any modern advantages of a fire piston?
How to prevent cleaner from hanging my lock screen in Ubuntu 16.04
Can a person refuse a presidential pardon?
Intern applicant asking for compensation equivalent to that of permanent employee
Can placing a counter on a creature after it has been assigned as an attacker remove it from combat
Why avoid shared user accounts?
How long is the D&D Starter Set campaign?
Writing a character who is going through a civilizing process without overdoing it?
How should I handle players who ignore the session zero agreement?
Pronunciation of umlaut vowels in the history of German
Advice for a new journal editor
what does しにみえてる mean?
Why zero tolerance on nudity in space?
Sybase IQ cache database result
How to add a column with computed columns with values of row on Sybase IQSybase: Replacement for TimeSeries()Query Cache Implementation DetailsDetermine if queries have small or large resultsSybase IQ identify hot partitionsHow to optimize constant querying for a sum of many rows?Sybase IQ cannot select by a calculated dateSample Sybase ASE 15.0.3 databaseAm I clearing the query cache correctly?Is it possible to delete cache in Mongo?
I'm using a query that calculates some values on a table with about 11 millions rows. And I need to display the results in real time (on my site), but this calculations need about 1min to execute. The table content changes each 30 mins, so I don't have to recalc the results at each time user reloads the page. How can I cache the results of calculations? Via php (I use odbc) or using some sql statement, some sybase IQ option. Thanks.
query-cache sybaseiq
asked Mar 17 '15 at 12:26
DariaDaria
11816
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I'm using a query that calculates some values on a table with about 11 millions rows. And I need to display the results in real time (on my site), but this calculations need about 1min to execute. The table content changes each 30 mins, so I don't have to recalc the results at each time user reloads the page. How can I cache the results of calculations? Via php (I use odbc) or using some sql statement, some sybase IQ option. Thanks.
query-cache sybaseiq
asked Mar 17 '15 at 12:26
DariaDaria
11816
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I'm using a query that calculates some values on a table with about 11 millions rows. And I need to display the results in real time (on my site), but this calculations need about 1min to execute. The table content changes each 30 mins, so I don't have to recalc the results at each time user reloads the page. How can I cache the results of calculations? Via php (I use odbc) or using some sql statement, some sybase IQ option. Thanks.
query-cache sybaseiq
asked Mar 17 '15 at 12:26
DariaDaria
11816
I'm using a query that calculates some values on a table with about 11 millions rows. And I need to display the results in real time (on my site), but this calculations need about 1min to execute. The table content changes each 30 mins, so I don't have to recalc the results at each time user reloads the page. How can I cache the results of calculations? Via php (I use odbc) or using some sql statement, some sybase IQ option. Thanks.
query-cache sybaseiq
query-cache sybaseiq
asked Mar 17 '15 at 12:26
DariaDaria
11816
asked Mar 17 '15 at 12:26
DariaDaria
11816
asked Mar 17 '15 at 12:26
DariaDaria
11816
asked Mar 17 '15 at 12:26
DariaDaria
11816
asked Mar 17 '15 at 12:26
DariaDaria
11816
11816
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
solved it by my own. Not optimized, but helpful for me. I insert my calculations into temp table, and add there a column with current date. On a script start I'm checking if table is older then 30mins, and if so, I drop it and crwate again.
answered Mar 17 '15 at 14:30
DariaDaria
11816
add a comment |
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%2f95454%2fsybase-iq-cache-database-result%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
solved it by my own. Not optimized, but helpful for me. I insert my calculations into temp table, and add there a column with current date. On a script start I'm checking if table is older then 30mins, and if so, I drop it and crwate again.
answered Mar 17 '15 at 14:30
DariaDaria
11816
add a comment |
solved it by my own. Not optimized, but helpful for me. I insert my calculations into temp table, and add there a column with current date. On a script start I'm checking if table is older then 30mins, and if so, I drop it and crwate again.
answered Mar 17 '15 at 14:30
DariaDaria
11816
add a comment |
solved it by my own. Not optimized, but helpful for me. I insert my calculations into temp table, and add there a column with current date. On a script start I'm checking if table is older then 30mins, and if so, I drop it and crwate again.
answered Mar 17 '15 at 14:30
DariaDaria
11816
solved it by my own. Not optimized, but helpful for me. I insert my calculations into temp table, and add there a column with current date. On a script start I'm checking if table is older then 30mins, and if so, I drop it and crwate again.
answered Mar 17 '15 at 14:30
DariaDaria
11816
answered Mar 17 '15 at 14:30
DariaDaria
11816
answered Mar 17 '15 at 14:30
DariaDaria
11816
answered Mar 17 '15 at 14:30
DariaDaria
11816
11816
add a comment |
add a comment |
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%2f95454%2fsybase-iq-cache-database-result%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
