Oracle 10g的结果缓存

Question

I've read that Oracle 11g has a results cache feature and I could really benefit from it. However, my client has Oracle 10g. Is there any sensible way to emulate it in a web application powered by PHP/5.2 that connects to a remote Oracle 10g server via ODBC (with Oracle's driver, not Microsoft's).

The idea is to cache complex queries on large tables that normally return small data sets and make sure that cached data gets discarded when the underlying tables changes (it doesn't need to be immediate, a one hour delay is acceptable).

I can install new software on the web server (not the Oracle server) and I could probably switch to OCI8 if necessary.

Answer 1

memcached is an option.

But your client needs to upgrade to 11g since 10g support ends on 31-Jul-2011, they could purcase extended support until 31-Jul-2013. (this info could have changed)