Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Does ODP also have a CacheType feature like OraOLEDB?
Dear All,
Does ODP.Net also have a CacheType feature like OraOLEDB?
Also if the value is set to file where is the file stored? on the DB
server or on the client?
Here is the description:
OraOLEDB-specific connection string attributes which affect the
performance of the
rowset are:
¦ CacheType - specifies the type of caching used by the provider to
store rowset
data. OraOLEDB provides two caching mechanisms:
¦ Memory - The provider stores all the rowset data in-memory. This
caching
mechanism provides better performance at the expense of higher memory
utilization. The default is Memory.
¦ File - The provider stores all the rowset data on disk. This
caching mechanism
limits memory consumption at the expense of performance.
Please help...
Thanks & regards
Sunil
Received on Mon Feb 27 2006 - 00:25:06 CST