News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Chris Jones' Blog:
Oracle 11g Result Caching and PHP OCI8
October 29, 2008 @ 07:52:33

Chris Jones has written up another post about a feature in some of the latest OCI8 libraries for PHP - result caching.

Oracle Database 11g introduced "server-side"and "client-side" result caches. The database cache is enabled with the RESULT_CACHE_MODE database parameter, which has several modes. With the default mode, queries for which you want results to be cached need a hint added - No PHP changes are required.

This caching is perfect for results from smaller lookup tables and can drop CPU usage by quite a bit. Oracle automatically takes care of validating the cache entries when something changes the stored results so your query is always fetching the latest (without having to worry about a timestamp on the cache or anything like that). He gives a few examples of how it would work, comparing the queries both with and without the caching.

0 comments voice your opinion now!
oracle oci8 driver cache result update tutorial 11g


blog comments powered by Disqus

Similar Posts

PHPMaster.com: Server-Side Device Detection with Browscap

FuzzyOpinions Blog: Tutorial: improving security with a PHP Captcha

Christopher Jones' Blog: PHP OCI8 1.3.3 has gone "Production"

Christoph Dorn's Blog: FirePHP on Magenting

Brandon Savage's Blog: Caching For Efficiency With Zend Framework


Community Events

Don't see your event here?
Let us know!


unittest release extension community php7 voicesoftheelephpant language framework laravel5 wordpress api library interview version series laravel example opinion introduction podcast

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework