Sample Header Ad - 728x90

Sybase IQ cache database result

1 vote
1 answer
165 views
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.
Asked by Daria (153 rep)
Mar 17, 2015, 12:26 PM
Last activity: Nov 26, 2020, 04:03 AM