Cache Payback

Thursday Jun 26th 2008 by DatabaseJournal.com Staff
Share:

Oracle Data Provider for .NET (ODP.NET) enables you to take advantage of features exposed by the underlying Oracle Call Interface. One such feature new in Oracle Database 11g Release 1 and Oracle Database 11g Release 1 Client is the client result cache.

[From OTN]

Oracle Data Provider for .NET (ODP.NET) enables you to take advantage of features exposed by the underlying Oracle Call Interface. One such feature new in Oracle Database 11g Release 1 and Oracle Database 11g Release 1 Client is the client result cache.

The client result cache is a portion of memory that is automatically allocated (on the client) to cache query results. Caching query results on the client makes it possible to avoid round-trips to the server to execute, query, and fetch data. This, in turn, leads to better performance and decreased resource consumption on the network and the server.

The article continues at http://www.oracle.com/technology/oramag/oracle/08-jul/o48odpnet.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved