I am using a query that calculates some values in the table with approximately 11 million rows and results me Need to be displayed in real time (on my site), but this calculation requires about 1min to be executed. Table content changes every 30 minutes, so I do not have to re-assess the results every time the user reloads. How can I cache the results of the calculation? Through PHP (I use the ODBC) or some SQL statement I am using, some Sybase IQ options. Thank you.
I also asked on this question. So sorry to duplicate, you can not find where a better place is.
Then I found the solution is not optimized, but for me assistant I have a temporary table in my Insert the calculation, and add a column with the current date. At the beginning of the script, I'm checking that the table is above 30mins, and if so, then I skip it and repeat it again.
No comments:
Post a Comment