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:
More on PHP and Oracle 11gR2 Improvements to Client Result Caching
March 04, 2011 @ 09:56:33

Chris Jones has posted more information to his Oracle blog about the caching and other improvements that come along with the Oracle 11gR2 release that can be used in PHP applications.

Oracle 11.2 brought several improvements to Client Result Caching. CRC is way for the results of queries to be cached in the database client process for reuse. [...] PHP OCI8 as a "client" of the database can use CRC. The cache is per-process, so plan carefully before caching large data sets. Tables that are candidates for caching are look-up tables where the network transfer cost dominates.

Like many of the other server-side tools Oracle has to offer, it's pretty simple to enable this caching. Before you had to add a custom bit to your query to tell it to enable the caching. Now it's as simple as setting it up on the CREATE or ALTER for the table - nothing extra for the developer to do.

0 comments voice your opinion now!
oracle caching client result create alter


blog comments powered by Disqus

Similar Posts

CodeForest.net: Android JSON-RPC client and PHP Zend Framework server

Nexen.net: Sudoku in PHP

Irakli Nadareishvili's Blog: Install PECL Memcache with XAMPP and PHP4

Hasin Hayder's Blog: Counting occurrence of a word in a String - Benchmarking of PHP functions

Anson Cheung's Blog: Create nodes in eZ Publish using PHP


Community Events

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


laravel5 language series symfony interview threedevsandamaybe introduction unittest opinion voicesoftheelephpant release laravel community library version security api extension framework podcast

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