Sfrgttk

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?

0

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

share|improve this question

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 | 

0

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

share|improve this question

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

share|improve this question

asked Mar 17 '15 at 12:26

DariaDaria

11816

share|improve this question

asked Mar 17 '15 at 12:26

DariaDaria

11816

share|improve this question

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

1 Answer
1

active

oldest

votes

0

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.

share|improve this answer

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
});


}
});

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

Name

Email

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

Name

Email

Required, but never shown

0

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.

share|improve this answer

answered Mar 17 '15 at 14:30

DariaDaria

11816

add a comment | 

0

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.

share|improve this answer

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.

share|improve this answer

answered Mar 17 '15 at 14:30

DariaDaria

11816

share|improve this answer

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