Geek asks and answers

Results Cache for Oracle 10g

I read that Oracle 11g has a result cache function , and I could benefit from it. However, my client has Oracle 10g. Is there any reasonable way to emulate it in a PHP / 5.2 based web application that connects to a remote Oracle 10g server via ODBC (with Oracle driver, not with Microsoft).

The idea is to cache complex queries on large tables, which usually return small data sets and ensure that cached data is discarded when the underlying tables are changed (this should not be immediate, one hour delay is acceptable).

I can install the new software on a web server (and not on an Oracle server), and maybe I could switch to OCI8.

+3
source share
3 answers

You can see materialized representations in a transferable database .

+3
source

memcached is an option.

But your client needs to upgrade to 11 g from the date of completion of 10g support on July 31, 2011, they can increase the amount of support until July 31, 2013. (this information could be changed)

+1
source

11gR2. 10.2.0.4. TimesTen, . . , . mviews, , , . , , .

0
source

More articles:


All Articles